Skip to main content
Solved

Using IF, and AND and OR formula using emojis

  • February 27, 2024
  • 2 replies
  • 39 views
khoner01
Forum|alt.badge.img+8

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

Best answer by TheTimeSavingCo

Try this:

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

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Try this:

IF( AND( {Date won} = "", {Lead score} >= 5, DATETIME_DIFF( TODAY(), {Inquiry received}, 'days' ) >= 90 ), 'Phone' )
Adam, Airtable Consultant - thetimesaving.company
khoner01
khoner01
Forum|alt.badge.img+8
  • khoner01
  • Author
  • Participating Frequently
  • February 27, 2024

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

TheTimeSavingCo
Terms & ConditionsAccessibility statement