Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Get rid of #ERROR!

Topic Labels: Formulas
187 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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!