Auto update dropdown list

Is it possible to automatically change a cell to one of the dropdown items based on another cell's contents? So, I have a column with a dropdown list and a column with a checkbox. If the checkbox is checked I want the cell with the dropdown list to automatically change to Closed in the row. Is this possible?

Find more posts tagged with

Comments

Andrée Starå

Hi Jeremy,

Yes, it is but if you need to use the other status options as well then they all have to be automatic thru a formula or we'd have to use a third-party service like Zapier or similar.

Would that work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Jeremy_P

Thanks Andree. I will work with that.

Andrée Starå

Excellent!

Happy to help!

Let me know how it goes and if you have questions!

Samuel Mueller

Does it have to be zapier? Can we create custom API's to do this?

Sign in to join the conversation!

Quick Links

Trending discussions

Smartsheet Performance Issue
By when the issue will be resolved?
Unable to Access Smart Sheet
Hi, I'm currently experiencing an issue with Repair Tracking smartsheet, which was created about three weeks ago. When attempting to access it, the page takes an unusually long time to load and eventually displays the following error message: Interestingly, other Smartsheets I’ve created are working fine—this issue seems…
Notifications Currently Experiencing Issues?
Hi All, I seem to be having a bunch of notification issues, and I'm wondering if anyone else is experiencing issues. Please keep in mind I have had these automations in place for over 2 years already & they always worked as expected. Is this a system-wide issue, or should I connect with Smartsheet Support? Issue 1 -…