Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

IF no date leave blank field

Topic Labels: Formulas
874 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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