Jan 22 2024 01:45 AM
Hi
This formula works well
=IFS(AND(ISBLANK(L2184),ISBLANK(P2184),ISBLANK(V2184)), "Not Completed", OR(Q2184>=TODAY(), V2184>=TODAY()), "Pending", M2184>=TODAY(), "Compliant", TRUE, "Expired")
But I have found some have the status Not Required so need this to appear in the column where it says Not Completed, Pending, Compliant and Expired too but tried a few ways but does not show and I know there is at least one in the data
It is in column Z2184
HELP please
Thanks