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
Loading comments…