This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

HOW TO App Formula for column CATEGORY (Text)

Posted on 11-04-2023 01:04 AM
sabar
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

 

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 366
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
AleksiAlkio
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM

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

View solution in original post

Jump to Solution
0 Likes
7 REPLIES 7
Top Labels in this Space