I have a SharePoint list and the three columns I am working with are Status (shows either complete or not complete), Due Date (shows when an item is due) and a new column (this is the calculated column I am attempting to create).
The four status that I am attempting to calculate for are:
Complete - if an item shows complete in the status column, my calculated column should show complete regardless.
Past Due - if an item does not show complete in the status column, and is past the due date.
Approaching due date - if an item does not show complete in the status column, and is 2 days out from being due.
Not started - an item that is not complete and does not meet the aforementioned criteria.
Examples (based on today's date of 1/16/2018): Item1 has a Due date 1/14/2018 and is completed. The new calculated column would show: Complete
Item2 has a Due date of 1/14/2018 and is not completed. The new calculated column would show: Past Due
All attempts that I have made in calculating this column have failed.