Forum Discussion
Formating automatic display of expired, open or closed
weknowsafety491519 , could you please clarify your logic a bit. Date Assigned that's when you opened the task. If exists, when the task is Expired if Deadline < TODAY(). If we before deadline it'll be always Opened? What is the trigger for Opened/Closed? And if Date Assigned is blank, what shall be the Status for the task?
SergeiBaklan Thank you for your request.
Yes, I will do my best to clarify my logic a bit.
I am including date that requires a date when the event is assigned to a person, at the same time a deadline is assigned to this issue and person to close the item.
I would like that the cells unders "Status" shows "expired", or "Open" or "closed" when I open the file.
I meant, let say, we have assigne a responsable, a date when the responsibility was assigned and the deadline when the issue must be done. If the item was assigned on March 20 2019 and the Deadline has been set up for March 31 2019 and I open the file on April 1 2019 and the item have not been done them in the cell "Status" shall say "EXPIRED"; or if I open the file on March 28 2019 and the item have not been defined a date of complition then the status must say "Open", or if when I open the file and the item hve been complete on March 22 then the status shall say "Closed".
Date Assigned that's when I opened the task. (YES)
The task is Expired if Deadline < DEADLINE defined.
If we before deadline it'll be always Opened? (YES)
What is the trigger for Opened/Closed? Opened if deadline is < or = to the deadline when I open the file.
Closed when the date completed is defined.
And if Date Assigned is blank, what shall be the Status for the task? The date assigned will be always defined.
I hope I could explain it.
Thanks
Jhon
- Thank you. So, you have one more column Date Completed, correct?
weknowsafety491519 , I can't download your file. For such sample
formula could be
=IF(C2>1,"Closed",IF(TODAY()>B2,"Expired","Open"))