Can I trigger an event when selecting a value from a dropdown list?


Dear all,

I have a column with a dropdown list. At the beginning of a project, the value for each dropdown/task is set to "Not started". As soon as the vale for the first task changes, I would like to change another field's value ([Start Date]1) to today's date. But only if it didn't contain a value yet, so I can use it to calculate the duration of the project. - Any hint or idea would be highly appreciated. Thank you! 😊

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!