Is there a way to keep a checkbox from being checked if a column is empty?
Using Smartsheet to manage action items. I'm trying to set a rule that if the status column has not been updated then then it cannot be checked as complete. So, basically I'd like the "Completed" checkbox column to be locked until the Status Update column has been populated.
Answers
-
HI @TamiR , I am not aware of a way to do this. You could, however, use conditional formatting to signal to the user whether it can or cannot be checked, or use another column to "flag" if the checkbox was checked incorrectly (using if() conditions). You could also use an automation to "uncheck" the checkbox if it was checked when certain conditions were or were not met. Not exactly what you are looking for, but one of these may work for you.
Be well,
- Scott
If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!
-
There is an automation for setting conditions that would lock or unlock rows. Not sure if that would help since it would be the entire row.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!