Apr 12 2022 03:39 AM
Hi All,
I have this formula:
=IF(E2>=TODAY(),"",IF(ISOWEEKNUM(F2)=ISOWEEKNUM(TODAY()),"Due Today",""))
However I would like to add an extra bit to this which is when column G is shown as complete then I want this message to change to change the message to task completed but the rest of the original function above will need to work as it currently does.
Thank you
Apr 12 2022 04:09 AM
=IF(G2="complete","task completed",IF(E2>=TODAY(),"",IF(ISOWEEKNUM(F2)=ISOWEEKNUM(TODAY()),"Due Today","")))
Maybe with this formula.
Apr 12 2022 05:42 AM
Apr 12 2022 06:07 AM
Which of the examples in the attached file doesn't work as expected? Maybe i didn't correctly understand what you want to do.
Apr 12 2022 06:28 AM