Formula to checkbox when option selected from dropdown
Comments
-
-
Hello Paul
That works perfectly, what if i need to add status B to the option and additional columns such as Issue 2 - Status Received, can this work also.
Really appreciate your help.
Regards Daniel
-
It can. The first step would be to list out all criteria that could potentially check the box. From there we can build out a formula that can cover everything.
-
Hello Paul
In summary the sequence as below:
=IF "Issue 1 - Status Received or Issue 2 - Status Received or Issue 3 - Status Received or Issue 4 - Status Received or Issue 5 - Status Received or Issue 6 - Status Received or Issue 7 - Status Received" is either "Status A or Status B" then "Approved for Construction" column is checked.
Regards Daniel
-
I don't know why, but my response keeps triggering Smartsheet's security. I took a screenshot of it in a Word Doc. Let me know if you are able to read it, and in the mean time I will be reaching out to them to see what's going on...
-
Hello Paul
This works perfectly, thanks again for the help really appreciated.
Regards Daniel
-
No worries. Happy to help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!