Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

If formula returning blank with no errors

Topic Labels: Formulas
Solved
Jump to Solution
534 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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