+8Hey 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”))
+33You 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.
+8You 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”))
)
Thank you!! It worked!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
