Need help with a formula

Topic Labels: Formulas
827 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi everyone! I’m creating an integrated content + social media calendar for my team. There are two tables:

  1. Editorial, for website content
  2. Social, for social content

On the Social table, each record has four “Copy” text fields for each social platform.

What I’d like to do is create a field which does the following:

a) If any “Copy” field contains text, display the relevant social platform name.
b) If the above returns multiple values, concatenate the string with ", ".

I’ve tried this formula, which works for a single entry / satisfies condition a):

IF({Twitter Copy} != "", "Twitter")

How would I go about creating a formula which satisfies both a) and b)?

Thank you very, very much in advance. :orange_heart:

2 Replies 2

Hi @Alex_Blanes - does this give you what you want?

CONCATENATE(IF({Twitter Copy}, "Twitter, ", “”), IF({Facebook Copy}, "Facebook, ", “”))

This concatenates values for each copy column (2 columns in this example - you can extend for 4 copy columns).

Screenshot 2019-03-24 at 21.40.22.png

The “problem” with this formula is that it forces a comma onto the end of every value even if there is only one value, i.e. "Twitter, ", but maybe this isn’t a problem for you.

Also FYI, you don’t need to have

IF({Twitter Copy} != “”, etc…

But can just have IF({Twitter Copy}

which translates as “if Twitter Copy exists”

Hope this helps!

It seems like you want to know which contents have the copy ready in which social platforms, isn’t it? I would use a Views for that, even a Copies table.