Help

Re: Get rid of #ERROR!

504 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Nedra_Hines
6 - Interface Innovator
6 - Interface Innovator

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

3 Replies 3

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!