Need help hiding checkboxes
I have a handful of project intake sheets, that ControlCenter looks at to automatically generate project files if approved. We have 2 types of projects that are intermingled on the sheets, and use 2 automations in CC. I'm now running into an issue with some users checking both approval boxes, and CC generates 2 sets of files for each project. I'm trying to use formula's to hide Option 2 if Option 1 is checked, or if the Attribute column is empty. Also hide Option 1 if the Attribute column is not empty. I have that part worked out via formula, problem is when I make it a column formula, the checkbox no longer functions. I also included a snip of the conditional formatting, which could work, but the checkbox is still visible with the column filled. Any ideas how to tackle this?
Option 1 formula: =IF(Attribute@row <> "", ".", "")
Option 2 formula: =IF(OR([Option 1]@row = 1, Attribute@row = ""), ".", "")
Answers
-
You can solve this by having the users submit a form instead of logging their request directly on the grid. Then in the form you can use logic to hide/show fields.
Otherwise there is no way to do this if users are entering their request via the grid directly.
All the best,
-Ray -
Thanks Ray. Those checkboxes aren't on the initial form that they submit from. The projects are on these sheets in a backlog status, when we're ready to proceed with them, the checkboxes act as the approval and trigger for CC to generate the documents.
I know it ultimately comes down to a user training issue, I'm just trying to protect them from themselves, and me not having to do routine cleanups on rogue sheets.
-
Ahh, I understand. Unfortunately there's no way to do that natively in a Smartsheet grid. Sorry
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!