# Create a "formula" group field from a "age" field

Topic Labels: Formulas
647 2
cancel
Showing results for
Did you mean:
6 - Interface Innovator

Hi, i have another thread here but it changed into this problem instead.

in the end i want a “age” field calculated from a “date” and i want to make a “formula” field that categories the age to groups.

so

I have a “date” field

and a “formula” field that calculates the age in one number “15” lets say

DATETIME_DIFF(TODAY(), {Date}, ‘years’)

and then have another “formula” field that groups all ages 1-100 in “1-12”, “13-18”, “19-29”, “30-45”, “46-60” and “61-100”

Formula found on internet but doesn’t work for me?

IF(
{Age} <= 12, ‘1-12’,
IF(
{Age} = 13, ‘13-18’,
IF(
{Age} = 14, ‘13-18’,
IF(
{Age} = 15, ‘13-18’
IF(
{Age} = 16, ‘13-18’
IF(
{Age} = 17, ‘13-18’
IF(
{Age} = 18, ‘13-18’
IF(
{Age} = 19, ‘19-29’
IF(
{Age} = 20, ‘19-29’
)
)
)

and so on…

then i could have a “app” with a “Chart” for: “1-12”, “13-18”, “19-29”, “30-45”, “46-60” and “61-100”
right??? or use the built-in group feature and group them all.

2 Replies 2
18 - Pluto

This seems to be a duplicate. How is this question different from the question at the end of your other post?

6 - Interface Innovator

Hi, thank you for the help in the other thread. yes is the same question, but the other one started a bit different and evolved into another question.