Get rid of #ERROR!

Hey everyone! Yes, I know this has been answered before and I’ve read several posts. I’m not an airtable expert and I do want to get rid of the #ERROR! result when {Monthly Rental Fee Renewal Date} field is blank:

IF(IS_BEFORE({DeStaging Date},{Monthly Rental Fee Renewal Date}),“No renewal charge”,CONCATENATE(DATETIME_FORMAT({Monthly Rental Fee Renewal Date},‘MM-DD-YY’)," | “,{Client Name},” | ",“Rental Fee Renewal Date”))

You can have it check to see if the field has anything in it before evaluating the rest of the formula. That would look like this:

IF({Monthly Rental Fee Renewal Date},

IF(IS_BEFORE({DeStaging Date},{Monthly Rental Fee Renewal Date}),“No renewal charge”,CONCATENATE(DATETIME_FORMAT({Monthly Rental Fee Renewal Date},‘MM-DD-YY’)," | “,{Client Name},” | ",“Rental Fee Renewal Date”))

)

I also just noticed that some of the quotation marks in the formula above are curly quotes instead of straight quotes. All the quotation marks need to be straight quotes.

Thank you!! It worked!

2 Likes

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.