Change a drop down value when a date is entered

Is there a way to change a drop down value from a select list when a date in a adjacent column is entered?

So if an Accounting Escalation Date is provided, I want to auto route it to Accounting Team. Item Owner has 3 values (Accounting Team, Air Operations, Escalations Team)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!