Sep 24 2021 06:09 AM
I'm a newbie and I have created a Sharepoint List basically to track tasks in a Sharepoint Online Site. I got 2 date columns named as "Due Date and Closed Date. Closed Date is populated once a user marks a task as completed, otherwise it's left blank. Trying to create a third calculated column named "Delay" that should return respective values when bellow conditions are met:
1. If Closed Date is equal or earlier than Due Date, value should be "In-time"
2. If Closed Date is later than Due Date, the value should be calculated as difference of number of days between Closed Date and Due Date (i.e. 3 Days).
3. If Closed Date is null/blank and today's date is equal or earlier than Due Date value should be "In-time". This value should be updated depending on when the user is accessing the list.
4. If Closed Date is null/blank and today's date is later than Due Date value should be calculated as difference of number of days between Due Date and today's date (i.e. 3 Days). This value should be updated depending on when the user is accessing the list.
Appreciate if anyone could help.