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! Go to Solution.
Something like..
LOOKUP(
MAXROW("TableName","BMI",
AND(
[Age]=[_THISROW].[Age],
[BMI]<=[_THISROW].[BMI]
)
),
"TableName","KeyColumn","Category")
User | Count |
---|---|
17 | |
12 | |
5 | |
5 | |
5 |