This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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....
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...
