Formula to add check to checkbox based on several other checkboxes
Hi all,
I am trying to create a formula that adds a check to a checkbox once a check has been added to 5 other checkbox fields in the same row. The other checkboxes are also automated and are checked based on other criteria (however, I don't think that matters here). Below is what I have so far, basically if ALL of these fields are checked I want a check, if ANY of the 5 checkboxes are not checked, I want it left unchecked:
=IF([Tech Complete]@row, "Complete", AND([Finance Complete]@row, "Complete", AND([Ops Complete]@row, "Complete", AND([QA Complete]@row "Complete" , AND([Training Complete]@row, "Complete", 1, 0)))))
Any help is appreciated!
Thanks,
Andrea
Best Answer
-
As an update, a colleague of mine was able to help me get the right formula. The updated formula is below.
=IF(AND([Comms Complete]@row = "Ready", [Finance Complete]@row = "Ready", [Ops Complete]@row = "Ready", [QA Complete]@row = "Ready", [Training Complete]@row = "ready"), 1, 0)
Thanks!
Answers
-
Hi,
At a quick glance, there is a comma missing from the formula. After row and before "Complete".
=IF([Tech Complete]@row, "Complete", AND([Finance Complete]@row, "Complete", AND([Ops Complete]@row, "Complete", AND([QA Complete]@row (MISSING COMMA) "Complete" , AND([Training Complete]@row, "Complete", 1, 0)))))
Hope this helps,
Melitta
-
Thanks Melitta - When I add the comma my error message changes. Previously, it was 'UNPARSEABLE' and now it is 'INVALID DATA TYPE'. Thoughts?
-
As an update, a colleague of mine was able to help me get the right formula. The updated formula is below.
=IF(AND([Comms Complete]@row = "Ready", [Finance Complete]@row = "Ready", [Ops Complete]@row = "Ready", [QA Complete]@row = "Ready", [Training Complete]@row = "ready"), 1, 0)
Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives