I am trying to get a box to check when specific conditions are met.
Hello,
I am trying to get a box in a cell to check (True) when three or more conditions are met. The conditions to be met are a box checked in the same row. ie if box 1 and box 2 and box 3 are checked (True) them check the box (True)
Here is what I have started it keep showing as invalid or unparseable
=IF(AND(Explorer@row = "true", Practitioner@row = "true", Professional@row = "true") > 0, 1, 0
Any help is greatly appreciated.
Best Answer

I am sure there is a few ways but I never cared much for using and unless I had to, here is a pretty simple if statement with a count that should work as well if you want a different option.
=IF(COUNTIF(Explorer@row:Professional@row, 1) = 3, 1, 0)
Unchecked one:
Answers

I should also mention that the cells are built as check boxes

Hi!
If you want the final checked only if all three are checked, try this:
=IF(AND(Explorer@row = 1, Practitioner@row = 1, Professional@row = 1), 1, 0)
For formulas with checkboxes they use 1 for true (checked) and 0 for false (unchecked).

I am sure there is a few ways but I never cared much for using and unless I had to, here is a pretty simple if statement with a count that should work as well if you want a different option.
=IF(COUNTIF(Explorer@row:Professional@row, 1) = 3, 1, 0)
Unchecked one:

That worked,
Thank you Kira You Rock!!

Cory and Kira, I want to apply this formula to the whole column but I do not have the option "convert to column formula"
I am not sure why it is not showing

I accidentally clicked on the check box when trying to open up the formula which erased the formula. Maybe you did the same thing, so long as the formula is in there I am able to convert it over to column.

Yes it seems the formula boxes are tempermental

Once you get that converted to a column that temperament goes away it seems.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!