Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 27, 2020 01:58 PM
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
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 27, 2020 02:44 PM
You have a misplaced closing paren. Try this:
IF(
AND(
{Status}="AM: Follow Up on Proposal",
{24 Hours}="2 Days"
),
"yes",
"no"
)
Reply
2 Replies 2
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 27, 2020 02:44 PM
You have a misplaced closing paren. Try this:
IF(
AND(
{Status}="AM: Follow Up on Proposal",
{24 Hours}="2 Days"
),
"yes",
"no"
)
Reply
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 27, 2020 02:58 PM
Thank you very much that worked
Reply