Looking to auto select a value from a drop down when previous field has any value

Basically I have a contact list and when any contact is input I need to default the next field "status" to be "open - assigned". So as soon as someone is assigned to that item it is no longer the default of new-unassinged and changes over to open-assigned.

I have been trying all sorts of formulas with no luck. Help :)

Best Answer


  • This was perfect. Thank you so much!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!