Assistance with indicating a blank outcome
I have a task tracking sheet.
Users can add a new task via a form. They can manage their tasks through a report filtered to them (I do not want them working on the master sheet).
When a task is closed I have the date completed (automatically captured).
However when someone adds a task in the form and closes it there and then the 'Date completed' is not captured.
I want to see how timely people are in managing their tasks.
For column Date Difference I have used the formula
=[Date Completed]@row - [End Date]@row
For column Timeliness Status I have used the formula
=IF([Date Difference]@row < 0, "Early", IF([Date Difference]@row = 0, "On Time", IF([Date Difference]@row > 1, "Late")))
I am stumped as to how to get the next bit right:
If "Status" is "Complete" and "Date complete" is blank then add 'NULL" to "Date Difference" and "On Time - Closed in Form" to Timeliness Status.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!