Set enum options based on value of another cell?
New to appsheet and hoping the community can help me out!
I am trying to create an enum type column that allows users to select from a list dynamically generated based on the number value of another column.
Sam has a [clearance] value of 5
Erin has a [clearance] value of 6
I would like them to be able to select a [level] value from a list of numbers from "1" up to and including their [clearance] value.
Sam would pick from a list of: 1, 2, 3, 4, 5
Erin would pick from a list of: 1, 2, 3, 4, 5, 6
Any suggestions of formulas or settings that I could apply to achieve these results would be of great help, thank you!
Posted Aug 14, 2025, 12:38 AM UTC
12