Formula with Dates and Conditional Icons


#1

I really enjoy Airtable. Although, I am having a terrible time with formulas in general even though I have looked at the resources online.

In this scenario I have been trying to expand upon the equation in the screen shot. If the value returned is 1 thru 3 I would like to show the number the equation in the image returns plus “:bell:.” If the value shows 0 or a negative number I would like it to show the returned value plus “:red_circle:” If the Value shows 4 thru 7 I would like it to show the returned value plus “:large_blue_circle:” Lastly if the value shows 8 or greater I would like it to show the returned value plus “:white_circle:”

Examples of what I would like to see in my cells are:
1🔔
5🔵
12⚪
-2🔴

Can anyone help with this? I have made multiple attempts but they have all failed. I think I must be making small errors. A misplaced comma or parentheses. Thank you in advance for anyone who can take a crack at it!!


#2
DATETIME_DIFF({Due Date}, TODAY(), 'days') & " " &
IF(
   AND(
      DATETIME_DIFF({Due Date}, TODAY(), 'days') >= 1,
      DATETIME_DIFF({Due Date}, TODAY(), 'days') <= 3
      ),
     "🔔",
     IF(
        AND(
           DATETIME_DIFF({Due Date}, TODAY(), 'days') >= 4,
           DATETIME_DIFF({Due Date}, TODAY(), 'days') <= 7
           ),
       "🔵",
       IF( DATETIME_DIFF({Due Date}, TODAY(), 'days') > 7,
         "⚪️",
          IF(DATETIME_DIFF({Due Date}, TODAY(), 'days') < 1,
            "🔴",
            BLANK()
          )
        )
      )
    )

That should do it.


#3

Thank You, Thank You, Thank You, Thank You… THANK YOU! That did it! Fantastic.