I have two columns when a date is inserted in the first column the second column adds 20 days and populates a date which is fine, however I keep getting an error in the second column when a date in the first column has not been entered, what do I need to add in the formula so if the date is blank in the first column no error will be returned in the second column, thank you guys!
But that seems to mess with formatting and you end up with results like “2019-07-16T00:00:00.000Z”. Someone else might have a better solution to that, but you could use a LEFT formula to trim everything past the actual date, leaving you with:
This should work, but when checking for blanks it’s usually better to drop the conditional statement. Airtable sometimes has trouble determining what is blank and what is not. I’m sure there are many others on the forum that can explain why this is much better than I can… I’ll try to find a better post about it and will link to it here.