Skip to main content

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:

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).

Try this:

IF(
AND(
{Date won} = "",
{Lead score} >= 5,
DATETIME_DIFF(
TODAY(),
{Inquiry received},
'days'
) >= 90
),
'Phone'
)

YESSS TYSM @TheTimeSavingCo ! Worked like a charm 😃 Annoyed because I didn't think about rearranging the formula in this way. Much appreciated! 

Reply


Terms & Conditions