Change Dropdown Option in Cell Depedning on Date


Hi all,

I have a column titled "Interview Date" where the date of an interview is inputted. I also have a column titled "Status" with two options - Open and Closed.

I am trying to make a formula that will set the status column to "Closed" if the interview date is in the past. I am trying the following but cant get it to work:

=IF([Interview Date]@row , < Today(), “Closed”, “”)

Any help would be greatly appreciated.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!