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
-
@Daniel_HR1 You are super close to getting your formula to work, remove the comma after [Interview Date]@row
=IF([Interview Date]@row < Today(), “Closed”, “”)
Answers
-
@Daniel_HR1 You are super close to getting your formula to work, remove the comma after [Interview Date]@row
=IF([Interview Date]@row < Today(), “Closed”, “”)
-
Be sure your [Interview Date]@row is formatted as a Date column and remove the ",". The logical expression should be [Interview Date]@row < TODAY().
Value if true "Closed"
Value if False "Open"
=IF([Interview Date]@row < TODAY(), "Closed", "Open")
-
That was an issue, thanks for your help!
Final formula was;
=IF([Interview Date]@row < TODAY(), "Closed", "Open")
If I wanted to change it so the action happens when the interview date is seven days in the past how would change that formula?
-
Hi Summer, that worked perfectly. Thanks for your help!
Final formula was;
=IF([Interview Date]@row < TODAY(), "Closed", "Open")
If I wanted to change it so the action happens when the interview date is seven days in the past how would I need to change that formula?
-
@Daniel_HR1 This formula will change the status to closed when the interview date is 7 days in the past
=IF([Interview Date]@row < (TODAY() -7), "Closed", "Open")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!