Forum Discussion

JenniferPeterso's avatar
JenniferPeterso
Qrew Member
5 years ago

Formula Checkbox to Handle an Either Or Criteria

I am trying to setup a workflow trigger to tell the users when a report package is ready for the next phase. We've added an optional task in that process for when there are revisions that need to be d...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago

try thus

If([# of Completed 1st Reviews]>0 and [# of Completed other task summary counts] >0,  true)



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
JenniferPeterso's avatar
JenniferPeterso
Qrew Member
5 years ago
Didn't quite get me there, but helped me figure it out.

I created a summary field of those tasks, and said that if the summary of the tasks equaled the summary of the completed tasks to return the true value.

Example: If([# of Final Report Reviews/Revisions]=[# of Completed Final Report Reviews/Revisions], true, false)

------------------------------
Jennifer Peterson
------------------------------