Using IF with DATETIME_DIFF

Ask the Community Formulas
#1

Hello Everyone here,I need to calculate the difference between the {Date} and today in days, and display “todo” or nothing if the number of days is >1.I tried this but I keep having errors :IF(DATETIME_DIFF({Date}, TODAY(), ‘days’)>1),“To do”, " ")

Any ideas stackers?

#2

You’ve got an extra parenthesis in your formula after “>1”. Remove that and it works. FWIW, you can also remove the " " at the end, as Stackby defaults to making the fallback value blank unless otherwise specified.