Formula to checkbox when option selected from dropdown
Hello
As per the screenshot below, im trying to have a formula that if Status A is selected from the column this will check the box within approved for construction.
is this possible.
Regards Daniel
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
Check out the Formula Handbook template!
