I'm trying to create a tracking list to track the status of jobs using SharePoint Online.
I want to use the categories:
'In Progress' = 7 days + from Due Date 'Requires Action' = Within 7 days from Due Date 'Close Out' = After Due Date
I have set up conditional formatting using Content Editor - Web Part. I am now trying to set up a 'Status' column that returns the correct outcome based on a time frame.
I have the following formula:
=IF(Date+7<[Due Date],"In Progress","")&IF([Due Date]<=Date,"Close Out","")
Note: Date = Today's date
This delivers the desired results for 'In Progress' and 'Close Out', however I am uncertain as to how to deliver the 'Requires Action' outcome between the two time periods. What should I add to the formula?