Skip to main content

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 👇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? 🙏

Switch(

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

,0,‘kids’

,1,‘teenagers’

,2,‘young’

,3,‘mature’

,4,‘older’

)

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?


Thanks Alexey.


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



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 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! 😀

Reply


Terms & Conditions