Skip to main content

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

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}), "🔴")

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! 🙂


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

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.

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! 🙂


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.

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!

Reply


Terms & Conditions