Skip to main content

IF Contains formula?

  • March 6, 2018
  • 6 replies
  • 84 views
M
Forum|alt.badge.img

Hi all,

I’ve been racking my brains all morning trying to figure out a formula for a table and could do with some assistance!

What I’m hoping to achieve if a traffic light system. If a record isn’t uploaded to YouTube or shared on Youtube, the field displays a red emoji, if a record is uploaded but not shared, it displays an amber emoji and if the video is uploaded and shared, it displays a green emoji.

Can an IF statement be used across 2 fields? What I am essentially looking for is an IF Contains formula! I got a certain portion of the way to an answer however, my formula was only working if the ONLY value in a field was YouTube (i.e no Facebook, Twitter)

If anyone could offer any assistance, I would greatly appreciate it!

Thanks,
Matt

      6 replies

      E
      Forum|alt.badge.img+17

      Yes, you can insert several conditions in an IF. In this case you could use the OR function: https://support.airtable.com/hc/en-us/articles/203255215-Formula-field-reference#logical

      IF(OR({Condition 1}, {Condition 2}), "🔴")

      M
      Forum|alt.badge.img
      • Matt_Downer
      • Author
      • New Participant
      • March 13, 2018

      Yes, you can insert several conditions in an IF. In this case you could use the OR function: https://support.airtable.com/hc/en-us/articles/203255215-Formula-field-reference#logical

      IF(OR({Condition 1}, {Condition 2}), "🔴")


      Thanks Elias, I’m afraid i’m still struggling. In your example, what would Condition 2 be; I’ve tried leaving it blank but unsurprisingly that didn’t work.

      Sorry to be stupid! :slightly_smiling_face:

      E
      Forum|alt.badge.img+17

      You want 2 conditions, one for every field to check, isn’t it?

      E
      Forum|alt.badge.img+17

      Check this: https://airtable.com/invite/l?inviteId=invDyoGcdbDRPpMYO&inviteToken=55c7855221b73616755022d39adc654a6ad2e97ec2e4479feddeaffe6da14cdf

      Anyway, I think maybe using Views is better, so you’d have Pending Sharing, for example.

      W
      Forum|alt.badge.img+5
      • W_Vann_Hall
      • Inspiring
      • March 13, 2018

      Thanks Elias, I’m afraid i’m still struggling. In your example, what would Condition 2 be; I’ve tried leaving it blank but unsurprisingly that didn’t work.

      Sorry to be stupid! :slightly_smiling_face:


      For YouTube, you could use

      IF(
    FIND(
        'YouTube',
        {Uploaded to:}
        ),
    IF(
        FIND(
            'YouTube',
            {Shared on:},
            ),
        '💚',
        '💛'
        ),
    '❤️'
    )

      (I entered that without testing; I think I got the right number of parentheses in it.)

      Essentially, it looks to see if it’s been uploaded; if not, it displays the red emoji. (Could it be shared but not uploaded? If so, I need to make a change.) If it has been uploaded, it looks to see if it’s been shared as well, if so, it displays the green emoji; otherwise, it shows the yellow.

        A
        • Aaron_Cordovez
        • New Participant
        • October 26, 2021

        For YouTube, you could use

        IF(
    FIND(
        'YouTube',
        {Uploaded to:}
        ),
    IF(
        FIND(
            'YouTube',
            {Shared on:},
            ),
        '💚',
        '💛'
        ),
    '❤️'
    )

        (I entered that without testing; I think I got the right number of parentheses in it.)

        Essentially, it looks to see if it’s been uploaded; if not, it displays the red emoji. (Could it be shared but not uploaded? If so, I need to make a change.) If it has been uploaded, it looks to see if it’s been shared as well, if so, it displays the green emoji; otherwise, it shows the yellow.


        Very helpful, thank you!

        Terms & ConditionsAccessibility statement