Mar 27, 2020 01:58 PM
Why would this return blank and no errors?
IF(AND({Status}=“AM: Follow Up on Proposal”,{24 Hours}=“2 Days”,“yes”,“no”))
Fields:
Status=Single select
24 Hours=Formula
Solved! Go to Solution.
Mar 27, 2020 02:44 PM
You have a misplaced closing paren. Try this:
IF(
AND(
{Status}="AM: Follow Up on Proposal",
{24 Hours}="2 Days"
),
"yes",
"no"
)
Mar 27, 2020 02:44 PM
You have a misplaced closing paren. Try this:
IF(
AND(
{Status}="AM: Follow Up on Proposal",
{24 Hours}="2 Days"
),
"yes",
"no"
)
Mar 27, 2020 02:58 PM
Thank you very much that worked