Skip to main content
Solved

Conditional Formatting Column

  • May 28, 2020
  • 2 replies
  • 26 views

Forum|alt.badge.img+5

Hello Airtable Community.

I’m actually not sure if the subject is the right for this question but it’s the closest I could think of.

I created a formula field to autofill out instagram.com prior to a profile name to save me re-typing it every time. (Thanks to Scottsworld for helping me with that)

"https://www.instagram.com" & {profilename}

Is there a way to only show instagram.com if a profilename is not empty? ie nothing will show in the formula field if profilename is empty. Hope this makes sense!

Best answer by Kamille_Parks11

Adjust your formula like so: IF({profilename}, "https://www.instagram.com" & {profilename}, "")

2 replies

Kamille_Parks11
Forum|alt.badge.img+27

Adjust your formula like so: IF({profilename}, "https://www.instagram.com" & {profilename}, "")


Forum|alt.badge.img+5
  • Author
  • Known Participant
  • May 28, 2020

Adjust your formula like so: IF({profilename}, "https://www.instagram.com" & {profilename}, "")


This made me SOOOOO Happy!!! Thank you soooo much!!! I can’t tell you how much this has helped me.