HOW TO App Formula for column CATEGORY (Text)

[sabar]

Hello fellow AppSheet users,

I am having some trouble with my formula appsheet. How to set app formula for column category based on table. Tq

[AleksiAlkio · Accepted solution]

Something like..
LOOKUP(
MAXROW("TableName","BMI",
AND(
[Age]=[_THISROW].[Age],
[BMI]<=[_THISROW].[BMI]
)
),
"TableName","KeyColumn","Category")

[sabar]

LOOKUP(
MAXROW("tableName","BMI",
AND(
[Age]=[_THISROW].[Age],
[BMI]<=[_THISROW].[BMI]
)
),
"TableName","Age","Category")

Tqtq...but the answer always = "underweight"

[AleksiAlkio]

Is your BMI column type in both tables a number? Is the formula reading the data from a correct table?

[sabar]

BMI column type decimal..I change to type number but the answer still "underweight"

[AleksiAlkio]

What is your formula exactly, and the table name where you have those base values?

[sabar]

Tq Mr AleksiAlkio for your help...i'm wrong input "keycolumn" ...

[AleksiAlkio]

You're welcome!