Oct 21 2022 10:33 AM
Hello Everyone,
I am trying to get the status as per below mentioned conditions and dates. Could you suggest on how to get that.
Due Date | Sent Date | KOC Date | PRE Date | Scheduling in Progress | FW Date | Complete Date | Status |
3/7/2023 | 7/28/2022 | 8/27/2022 | 9/21/2022 | 10/16/2022 | 11/10/2022 | 12/10/2022 |
Oct 21 2022 11:01 AM
=IFS(KOC_Date<=TODAY(), "KOC Sent on Time", PRE_Date<=TODAY(), "PRE on Time", Scheduling_in_Progress<=TODAY(), "Scheduled on Time", FW_Date<=TODAY(), "FW on Time", Complete_Date<=TODAY(), "Complete on Time", TRUE, "None on Time/Other")
Oct 26 2022 04:36 AM
Oct 26 2022 11:18 AM
The formula does exactly what you asked in the first post, but apparently it is not what you wanted.
In which order should the formula check the conditions?