Scott_Ogier - profile

Scott_Ogier · Jul 09, 2020

Hi there, I am a relatively new Airtable user with a basic understanding of formulas which has held me in good stead until this week. I have a table linked to a form. It’s a form designed to use for a customer to hire various types of product for us....

Scott_Ogier · Jul 11, 2020

Justin - you are phenomenal. Truly. Speedy reply and a can’t thank you enough. That works like a charm. Really appreciate that.

Scott_Ogier · Jul 09, 2020

I just realised that the following formula works for me: IF(DATETIME_DIFF({Date for prop return}, {Date for prop collection}, “days”),0) Adding the IF formula replaces the NaN and allows the other cells to function with the mathematic equation. Thank...

User Statistics

User Activity

Formula problem - needing to convert an NaN to "0"

Re: Formula problem - needing to convert an NaN to "0"

Re: Formula problem - needing to convert an NaN to "0"