Valid If formula in enum list

so i have a colum named “How many people in this team” so basically it a enum type of column with value 1-20 and theres a enumlist type column named “name”. Is there a way to limit the selected enum list so if the user input 5 in “how many people in this team” then user only can select 5 names in “name” column

First, I would suggest to re-define this column as a Number, use the Range selection type and set the min = 1 and the Max = 20. It would look like this:

Screen Shot 2021-10-14 at 9.46.07 AM

For the “name” column, you are likely already using the Valid_If to set the list of names to be selected in an EnumList. So, you can’t also use validation to limit the number of selected names on that column.

What I do in these situations is add another column that simply validates the selected number of names. It is only shown if there is an error.

For example, maybe this new column is named “Selected Names Test”.

Show_If is set to:

COUNT([names]) <> [How many people in this team]

Valid_If is set to:

COUNT([names]) = [How many people in this team]

The “Invalid value error” is set to a message something like:

"The number of selected names must equal how many people are to be in this team"

You may need to tweak the details to fit your circumstances but this is a solid workaround when there is a need to limit or validate the choices of an EnumList.


works perfectly thank you very much

1 Like