Auto update dropdown list

Jeremy_P

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? 

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?