How to create where clause in quickbase
Hi Everyone! I'm pretty much new to Quickbase so I'm having some issues in creating formulas in Quickbase! Basically the problem here is that I don't know how to create "where clauses" in Quickbase. ...
Forum Discussion
You would use a nested if, the WHERE condition precedes the secondary conditional. What this does is evaluate the first conditional and everything that meets the condition is displayed in the cell. Then if the first condition fails the second condition is evaluated, if it is true then that value is displayed. Finally if the second condition fails, the final displayed value is 0.
If ([Project - ProjID]="AD0014" and [Project classification]="Training", ,
If([Project - ProjID]="AD0014" ,([Volunteer and Training Time Sheet Cost]+),0))
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------
If ([Project - ProjID]="AD0014" and [Project classification]="Training", ,
If([Project - ProjID]="AD0014" ,([Volunteer and Training Time Sheet Cost]+),0))
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------
