Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

If formula returning blank with no errors

Topic Labels: Formulas
Solved
Jump to Solution
1590 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Casey_Kleiman
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

You have a misplaced closing paren. Try this:

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

See Solution in Thread

2 Replies 2
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

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