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.
Dec 20, 2021 08:59 AM
Hello! Here’s what I’m hoping to accomplish:
Thanks for your help!
Dec 20, 2021 11:18 AM
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.