HOW TO App Formula for column CATEGORY (Text)

 

sabar_0-1699085702899.png

 

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

Solved Solved
0 7 363
1 ACCEPTED SOLUTION

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

View solution in original post

7 REPLIES 7
Top Labels in this Space