
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 04, 2023 05:33 AM
I don't understand why this formula isn't working ... I can only think it has something to do with the Now() calculation.
IF({Quote Status}="Selected" And(Now()) > {Scheduled Date},
{Scheduled Date},
IF({Quote Status} = "Fulfilled",
{Adj. Fulfilled Date},
{Dummy Date})
)
Any thoughts?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 04, 2023 05:48 AM
Here's how to use AND in Airtable.
IF(
AND(
{Quote Status}="Selected",
Now() > {Scheduled Date}
),
{Scheduled Date},
IF({Quote Status} = "Fulfilled",
{Adj. Fulfilled Date},
{Dummy Date}
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 04, 2023 05:37 AM
I did check the time zone in the date fields and they are all the same.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 04, 2023 05:48 AM
Here's how to use AND in Airtable.
IF(
AND(
{Quote Status}="Selected",
Now() > {Scheduled Date}
),
{Scheduled Date},
IF({Quote Status} = "Fulfilled",
{Adj. Fulfilled Date},
{Dummy Date}
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 04, 2023 08:13 AM
Sho! Thank-you!
I would NEVER have solved it without your help.
