Checkbox Formula Field Error
Looking to make a simple little formula field (Checkbox) where if the Task Name is called "Hosted Weekly Call" & the Status= Completed it will mark the task as "True" and check the box. I'm getting a...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendAn "&" means concatenation
Try this
If([Task Name]="Hosted Weekly Call" and [Status]="Completed","True","
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
How would I make this an OR statement with multiple scenarios?
[Task Name]="Hosted Weekly Call" and [Status]="Completed"
OR
[Task Name]="External Kick-Off Call " and [Status]="Completed"
OR
[Task Name]="Internal Kick-Off Call " and [Status]="Completed"
I get an error that says their are extra characters beyond the end of my formula. Do I have to change this into an If statement?
Thank you
------------------------------
Jack Woods
------------------------------
Individual sets of criteria have to be enclosed in parentheses ()
Criteria A OR
(Criteria B AND Criteria C)
For your example, I would set it up like this:
[Status]="Completed" AND ([Task Name]="Hosted Weekly Call" OR [Task Name]="External Kick-Off Call " OR [Task Name]="Internal Kick-Off Call ")
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------Awesome - thank you!
------------------------------
Jack Woods
------------------------------
