Skip to main content

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

You have a misplaced closing paren. Try this:

IF(
   AND(
      {Status}="AM: Follow Up on Proposal",
      {24 Hours}="2 Days"
   ),
   "yes",
   "no"
)

You have a misplaced closing paren. Try this:

IF(
   AND(
      {Status}="AM: Follow Up on Proposal",
      {24 Hours}="2 Days"
   ),
   "yes",
   "no"
)

Thank you very much that worked