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?
I did check the time zone in the date fields and they are all the same.
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}
)
)
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}
)
)Sho! Thank-you!
I would NEVER have solved it without your help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.