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
Good morning,
I would think that you want this Formula to apply to any record inside of your data not just the ProjectID AD0014.
Also, it is unclear what you are trying to accomplish and the makeup of your data. In order to only calculate this value when the Project Classification="Training, then you can simply add "and [Project Classification]="Training", like this.
If ([Project - ProjID]="AD0014" and [Project Classification]="Training,([Volunteer and Training Time Sheet Cost]+),0)
I would recommend considering removing [Project - ProjID]="AD0014" and it would become If([Project Classification]="Training,([Volunteer and Training Time Sheet Cost]+),0)
------------------------------
John Crosland
------------------------------
I would think that you want this Formula to apply to any record inside of your data not just the ProjectID AD0014.
Also, it is unclear what you are trying to accomplish and the makeup of your data. In order to only calculate this value when the Project Classification="Training, then you can simply add "and [Project Classification]="Training", like this.
If ([Project - ProjID]="AD0014" and [Project Classification]="Training,([Volunteer and Training Time Sheet Cost]+),0)
I would recommend considering removing [Project - ProjID]="AD0014" and it would become If([Project Classification]="Training,([Volunteer and Training Time Sheet Cost]+),0)
------------------------------
John Crosland
------------------------------
