Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

If formula returning blank with no errors

Topic Labels: Formulas
Solved
Jump to Solution
1858 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