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
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!