I'd like to build a field that returns the days until due if >0, or "Assign Due Date" if Nan, or "Passed Due" if <0.I am struggling to combine the IF statement with the following formula:DATETIME_DIFF({Deadline},TODAY(),'days')Any tips on how to acco...
Solved! Took a lot of trial and error, but got there in the end.IF(DATETIME_DIFF(Deadline,TODAY(),'days')>0,DATETIME_DIFF(Deadline,TODAY(),'days'),IF(DATETIME_DIFF(Deadline,TODAY(),'days')<0,"Passed Due","Assign Due Date"))
