IF Contains formula?


#1

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


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


#3

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! :slight_smile:


#4

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


#5

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.


#6

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.