Solved

If formula returning blank with no errors

+10

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

Best answer by Jeremy_Oglesby

You have a misplaced closing paren. Try this:

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

+18

You have a misplaced closing paren. Try this:

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

+10

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

Sign up