Enum Value Choices in Number Increments

[Allison_Romero1]

I am having trouble wording this so I’ll just get into it:

I have a numerical column (column A) that displays a total. I have an Enum column (column B) that I need the list value choices to be this number but in ascending order in increments

Example:
If Column A = 5
Then Column B Enum Value options need to be: (1, 2, 3, 4, 5)

Or in other words, “there is 5 available, how many do you want to use?” and the user would select a number

I know I need to have an expression formula in “Valid If” to do this. What would that formula expression be if it is possible?

Thank you!

[Rafael_ANEIC-PY]

Hello @Allison_Romero1, welcome to the community !

If i understand right, you want the user to pick a number that is only allowed within a range that depends on the value of column A?

Why not use a number column with no decimals then? and you can use a valid_if expression like:

[_THIS]<=[Column_A]

You can even set it up to allow increments of one with the +/- buttons

[Allison_Romero1]

Thank you for the reply.
For some reason, that expression didn’t work for me.

I took some screenshots to better explain, this is how i want it to work if possible (I manually entered 0-7 as values for this screenshot):

[Steve]

To get the first so-many (as determined by [column A]) values in a sequence:

TOP([column A], {1, 2, 3, ..., N})

where 1, 2, 3, ..., N is the sequence of all possible values.

[Allison_Romero1 · Accepted solution]

Thank you, Steve! I had to flip it to

TOP({1, 2, 3 …}, [column A])

but it is exactly what I needed!