Forum Discussion

reemav's avatar
reemav
Copper Contributor
Mar 10, 2022
Solved

Help with Excel Function to return the correct status

Hi, 

 

I have an excel sheet where i need the "Status" column to either return a blank, "open", "overdue" or closed" status depending on the following scenarios:

 

If "Target" and "Completion" columns are blank then "Status" column should be blank too.

If "Target" has a date entered and "Completion" is blank then "Status" column should return "Open".

If "Target" and "Completion" columns both have dates then "Status" column should return "Closed".

However, if "Target" date has past today's date and "Completion" column is blank then "Status" column should return "Overdue".

 

 

i had used this formula but it's not showing the correct status:

=IF(J8=K8="","",IF(J8<>""=K8<>"","Closed",IF(J8<O1,"Overdue",IF(J8<>"","Open"))))

 

 

 

 

2 Replies

    • reemav's avatar
      reemav
      Copper Contributor
      Thank you so much! Yes that's exactly what i was looking for 🙂

Resources