Help

IF no date leave blank field

Topic Labels: Formulas
1699 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Louisa_Johnson
4 - Data Explorer
4 - Data Explorer

I used the DATETIME_DIFF({Date Due}, TODAY(), ‘days’) formula to give me the number of days until the due date, however, how do I put an IF statement in if there isn’t a start / due date?

4 Replies 4

Hey Something like this should work. Your return values are seperated by commas. Your first value is your original formula, and your second is the value you want if there isn’t a date.

IF({Due Date}, DATETIME_DIFF({Date Due}, TODAY(), ‘days’), "**IF THERE ISN'T***")

Thank you, but that didn’t work. Says there’s an error in the formula.

You have to change the quotation marks in 'days'

So it should be

IF({Due Date}, DATETIME_DIFF({Date Due}, TODAY(), 'days'), Blank())

Thankyou so much for this! Helped me too. Wondering if you can help me further - the formula is calculating the right number, except it’s returning a minus in front of the number for some reason. Any ideas how I can fix this?

IF({DOB}, DATETIME_DIFF({DOB}, TODAY(), ‘years’), BLANK())