If-Then-Else + Template

Ask for Help
1

Hi, I am trying to create something similar to and if+concatenate excel formula.

If {Name} ‘is not empty’ the this Template
If {Name} ‘is empty’ the this Template

Is that posisble to do as using one column type?

Thanks

2

How different are the templates?

I’d probably use a single template column, then one or more if-then-else columns to feed values into the template.

3

They are very similar. The two options are:

‘A-B-C’ or ‘B-C’

It is dependent on A not being empty

4

Okay, so you might be better off with two template columns, then you don’t have to mess around with the dangling dash when A is empty.

So…

  • Create your two template columns
  • Then a single if-then-else column:
    – If A is not empty, then Template A
    – Else Template B
1 Like
5

great, I’ll give it a go.

6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.