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
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?