If formula for checkboxes
Hi, I am having trouble with the correct formula sequence for check boxes to stay checked through out the workflow process?
I want the check boxes to stay check as it moves along its stages.
current formula I am using is:
100% Rec'd column =IF([Workflow Status - BitRip]@row = "Received", 1)
Shop Installed column =IF([Workflow Status - BitRip]@row = "Shop Installed", 1)
100% Delivered =IF([Workflow Status - BitRip]@row = "Delivered", 1)
Field Installed =IF([Workflow Status - BitRip]@row = "Field Installed", 1)
100% QC'd =IF([Workflow Status - BitRip]@row = "QC'd", 1)
Workflow Status - BitRip; drop down values are:
any help is appreciated 😊
Best Answer
-
Hello @kaowser ! If you're using a formula, whenever the status changes, the checkboxes will change. Instead, if you want a status to mark a checkbox, and then a status change marks a new checkbox but leaves the other one checked because that was completed, you should use an automation.
The automation would be trigger when status changes to Received, change cell value "100% rec'd" to checked. Then you can duplicate that automation and set it up for each status.
Hope that helps!
Answers
-
Hello @kaowser ! If you're using a formula, whenever the status changes, the checkboxes will change. Instead, if you want a status to mark a checkbox, and then a status change marks a new checkbox but leaves the other one checked because that was completed, you should use an automation.
The automation would be trigger when status changes to Received, change cell value "100% rec'd" to checked. Then you can duplicate that automation and set it up for each status.
Hope that helps!
-
Thank you Victoria! the automations helped a lot!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!