Checkbox based off of dropdown selection.
I'm trying to create a formula in a checkbox column. This column is called complete. I would like the complete column to automatically check once one of two statuses from a status column is selected. The status column has a number of statuses, but the two I need are "Hold/Cancelled" and "Complete".
I created an IF statement if one of the criteria are met, but I can not get the two to work together.
=IF(Status2 = "Hold/Cancelled", 1)
=IF(Status2 = "Complete", 1)
How do I get these two within one statement to work together.
Comments
-
You can accomplish this by using the OR operator in your function.
=IF(OR(Status2 = "Hold/Cancelled",Status2 = "Complete"),1,0)
-
Dave, you are a genius. I can't tell you how long I fought with that syntax. This worked like a charm. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!