Formula for changing drop-down selection in one column when a date is entered in another column

Options

I have a status column with drop-down options (Not Started, In Progress, Complete, N/A). I would like the drop down selection to change to Complete when I enter a date in the Complete Date column. Is this possible?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!