Is there a way to have a formula tell you if a deadline is upcoming instead of just before and after?

[Lauren_Azicri]

Hi all,

I am trying to format a field to show whether a deadline is “On Time” (before deadline due date), “At Risk” (same day as deadline due date) and “Late” (past deadline due date/time).

Is this possible? I keep getting lost in my nested if statements and when I add another component, I am getting blank records.

Thanks,
Lauren

[Lauren_Azicri]

Thank you for this information! I will check these out and see which works best for me to understand formulas better!