- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 26, 2024 05:49 PM
I struggling to correct a formula where I want the return value to appear based on IF AND statements.
Goal I am trying to achieve:
- I DO NOT want the phone emoji to appear in the “follow-up” column if the “lead score” is below 5 (Eg: 0, -5, -15).
Here is a short Loom where I walk through what I want to fix: https://www.loom.com/share/82b6cdb91b12403d96fdb047760e01e0?sid=bdca5f77-58d9-478e-bfbd-6395874742dc
Below is my current formula:
IF(DATETIME_DIFF(NOW(), {📧 Inquiry received}, 'days')>=90, IF(NOT({🎉 Date Won}),"📞 ",""))
What I want the formula to say:
- If the “inquiry received” date is greater than or equal to 90 days, if the “date won” is empty, and if the “lead score” is greater than or equal to 5, then the “follow-up” column will return a phone emoji.
Screenshot with notes:
Current formula:
Current formula
I DO NOT want the phone emoji to appear in the “follow-up” column if the “lead score” is below 5 (Eg: 0, -5, -15).
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 26, 2024 05:57 PM
Try this:
IF(
AND(
{Date won} = "",
{Lead score} >= 5,
DATETIME_DIFF(
TODAY(),
{Inquiry received},
'days'
) >= 90
),
'Phone'
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 26, 2024 05:57 PM
Try this:
IF(
AND(
{Date won} = "",
{Lead score} >= 5,
DATETIME_DIFF(
TODAY(),
{Inquiry received},
'days'
) >= 90
),
'Phone'
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 26, 2024 06:07 PM
YESSS TYSM @TheTimeSavingCo ! Worked like a charm 😃 Annoyed because I didn't think about rearranging the formula in this way. Much appreciated!
