Formula

Kaseem Gomez

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.

Paul Newcome

Try this:

=IF([Run Date]@row > TODAY(), "Upcoming", IF([Finish Date]@row > TODAY(), "Active", "Past"))