mlight - profile

mlight · Jun 22, 2024

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...

mlight · Jun 22, 2024

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"))

User Statistics

User Activity

Formula to return both a calculation and text?

Re: Formula to return both a calculation and text?