Forum Discussion

Cathycathy43's avatar
Cathycathy43
Copper Contributor
Sep 23, 2023

Help with Formula not sure if it should be IF IFS OR AND

Current Todays date in J1 Column I             Column J                 Column K Due Date Current| Completed Overdue   Date Completed 1-Aug-23     1-Aug-23   31-Aug-23 31-O...
Formulas and Functions
mtarler's avatar
mtarler
Silver Contributor
Sep 23, 2023
try:
=IFS(ISNUMBER(K2:K4),"Completed", TODAY()>I2:I4, "Current", TRUE, "Overdue")
  • Cathycathy43's avatar
    Cathycathy43
    Copper Contributor
    Sep 24, 2023

    mtarler thank you - I’ll try this in the morning. 
    appreciate the time you took to reply.