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 an error in my code though. please advise.
If([Task Name]="Hosted Weekly Call" & [Status]="Completed","True","False")
Getting a code error that the operator = can't be applied on types bool,text
Qrew LegendAn "&" means concatenation
Try this
If([Task Name]="Hosted Weekly Call" and [Status]="Completed","True","
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
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/
------------------------------
