Formula
Is there a formula that can help me automate data entry into the placement status column based on Run and Finish date? As per the example below, the row with the upcoming status gets an upcoming placement status because the run date (8/5/24) and finish date (8/5/24)has not been reached. Also, the first column that has a placement status of past gets a past status because the run and finish date have happened already, and lastly the a placement status of active will be given to a row if the run date has been reached, but the finished date has not. For example, a row with a run date of (7/08/24) and a finish date of (8/23/24) should get an active date.
Answers
-
Try this:
=IF([Run Date]@row > TODAY(), "Upcoming", IF([Finish Date]@row > TODAY(), "Active", "Past"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!