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.

Help with nested IF statements

Topic Labels: Formulas
374 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello! Here’s what I’m hoping to accomplish:

image

  1. If {Inventory Arrived?} = ‘Inventory Arrived’ and HAS a date in {When did Inventory Land?} use that date.
  2. If {Inventory Arrived?} = ‘Inventory Arrived’ and DOESN’T have a date, use {Updated Estimated Delivery Date} date
  3. If {Inventory Arrived?} = ‘Inventory Not Arrived’, use {Updated Estimated Delivery Date}

Thanks for your help!

1 Reply 1

Hi Rachael. From what you wrote, there are only two options for the answer you want - {When did Inventory Land?} or {Updated Estimated Delivery Date}. So, you could use…

IF(AND({Inventory Arrived?}='Inventory Arrived', {When did Inventory Land?}), 
       {When did Inventory Land?}, 
       {Updated Estimated Delivery Date})

Let us know if works the way you want. Good luck.