Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Help with an if then concatenated formula

Topic Labels: Formulas
Solved
Jump to Solution
3290 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Jose_Alberto_Fu
6 - Interface Innovator
6 - Interface Innovator

For a casting agency db I need to set a personalized filter column

I have a field with the age, now I need a formula column that gives me the segment :point_down:t2:

AGE CALCULATED COLUMN
< 15 kids
=> 15 & < 18. teenagers
=> 18 & < 31 young
=> 31 & < 45 mature
=> 45 older

I’ve been trying to make an if then concatenated formula but I’m always getting errors.

Any help? :pray:

1 Solution

Accepted Solutions

i think, it’s quotes, the forum substituted usual symmetric single quote
by left/right quotes…
my fault, i should have select formula text to avoid it.
correct version (substitute only lower part, with quotes)

Switch(
(age>15)+(age>18)+(age>31)+(age>45)

,0,'kids'
,1,'teenagers'
,2,'young'
,3,'mature'
,4,'older'
)

See Solution in Thread

4 Replies 4

Switch(
(age>15)+(age>18)+(age>31)+(age>45)
,0,‘kids’
,1,‘teenagers’
,2,‘young’
,3,‘mature’
,4,‘older’
)

Thanks Alexey.

I’m getting an error. Maybe am I missing something?

image

i think, it’s quotes, the forum substituted usual symmetric single quote
by left/right quotes…
my fault, i should have select formula text to avoid it.
correct version (substitute only lower part, with quotes)

Switch(
(age>15)+(age>18)+(age>31)+(age>45)

,0,'kids'
,1,'teenagers'
,2,'young'
,3,'mature'
,4,'older'
)

I see! Thanks so much. It works like a charm! :grinning: