Original Message:
Sent: 12-29-2020 14:19
From: Blake Harrison
Subject: Checkbox Formula Field Error
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/
Original Message:
Sent: 12-29-2020 13:39
From: Jack Woods
Subject: Checkbox Formula Field Error
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
Original Message:
Sent: 12-21-2020 11:44
From: Mark Shnier (YQC)
Subject: Checkbox Formula Field Error
An "&" means concatenation
Try this
If([Task Name]="Hosted Weekly Call" and [Status]="Completed","True","False")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
Original Message:
Sent: 12-21-2020 11:42
From: Jack Woods
Subject: 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 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
------------------------------
Jack Woods
------------------------------