Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 28, 2023 03:21 AM
Hi there;
I'm very new both to Airtable and formulae, so I hope this is just a beginner's issue and is not a function or possibility currently beyond the possibilities Airtable provides.
I have a formula field (Sim Required?) that I would like to populate a green checkmark from a combination of possible options in the multiple select field (TikTok / Instagram / Router).
The multiple select field has 4 options:
TikTok 1, TikTok 2, Instagram and Router.
I would like the green checkmark to appear under these conditions:
TikTok 1 only is selected.
TikTok 2 only is selected and
Both TikTok 1 and TikTok 2 are selected.
I've managed to have the checkmark appear only when TikTok 1 is selected; when I try with only TikTok 2 or a combination of 1 and 2, the green checkmark doesn't appear.
Thanks for any help you provide,
Solved! Go to Solution.
Oct 29, 2023 06:26 AM
Thank you Arthur! I tried it, replacing Social Media with the correct field name, but it didn't work, even though it did work for you. That is a pickle.
That being said I tried this and it worked:
IF({TikTok / Instagram / Router} = “TikTok 1,” {TikTok / Instagram / Router} = “TikTok 2,” {TikTok / Instagram / Router} = “TikTok 1,”, “TikTok 2" "🟢",
IF( OR({TikTok / Instagram / Router} = “Instagram”, {TikTok / Instagram / Router} = "Router"), "🔴"))
Oct 28, 2023 06:34 AM
@MaddieJ Here is an example of a question where I know of two possible formulas that might work. I tried typing them on my phone, but ultimate gave up after several tries because trying to type multi-line formulas with this level of nesting on mobile is just too hard on Khoros. I am also away from a computer for several days, and who knows if I will stumble on this thread when I have access to a computer again.
Hopefully someone else will chime in with a solution.
Oct 28, 2023 10:03 AM
Thank you kuovonne!
Oct 28, 2023 07:48 PM - edited Oct 28, 2023 07:49 PM
Hey @Sidney1983 ! Try this formula out (Adjust to match the name of your fields/data)
IF({Social Media} = 'TikTok1', '', IF({Social Media} = 'TikTok2', '', IF(OR({Social Media} ='TikTok1, TikTok2', {Social Media} ='TikTok2, TikTok1'), '')))
@kuovonne curious if you thinking along the same lines.
Oct 29, 2023 06:26 AM
Thank you Arthur! I tried it, replacing Social Media with the correct field name, but it didn't work, even though it did work for you. That is a pickle.
That being said I tried this and it worked:
IF({TikTok / Instagram / Router} = “TikTok 1,” {TikTok / Instagram / Router} = “TikTok 2,” {TikTok / Instagram / Router} = “TikTok 1,”, “TikTok 2" "🟢",
IF( OR({TikTok / Instagram / Router} = “Instagram”, {TikTok / Instagram / Router} = "Router"), "🔴"))