Is it possible to have a column only be available to be selected based on the status of another?

RPlaud · 05/22/24

I have a drop down column that captures the study status and I have another column that is a check box indicating the information has been reviewed. Is there anyway to have the option to select the "information reviewed" column only when the study status column reads "completed?

Andrée Starå · 05/22/24

https://community.smartsheet.com/discussion/122316/is-it-possible-to-have-a-column-only-be-available-to-be-selected-based-on-the-status-of-another

Hi,

I hope you're well and safe!

Yes!

Here's a possible workaround or workarounds

- Have a workflow with the change a cell action to remove a punctuation or similar from the checkbox sp it's checkable.
- Add a message together with conditional formatting when it's ready or not.

Would any of those options work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

RPlaud · 05/29/24

I am not sure I understand would you mind providing an example? Thank you in advance!

Lucas Rayala · 05/30/24

https://community.smartsheet.com/discussion/comment/437268#Comment_437268

Love this! Hadn’t thought to do this. As an addition, I use a “blank” emoji character when I want to make a checkbox disappear.

Is it possible to have a column only be available to be selected based on the status of another?

Answers

Help Article Resources

Categories