Valid if dropdown as well as invalid error message

Hi,

I would like to have a enumlist column [occupied] which has a dropdown menu with a list of people who are attendees, by reading two other columns and using this formula as a valid_if:

LIST([head]) + [attendees]

I would also like the [occupied] column to show an invalid message if more than 5 entries are selected.

What I tried:

AND(
LIST([head]) + [attendees],
COUNT([_THIS]) > 5
)

This of course gives the error: invalid structure: subexpressions must be Yes/No conditions.

Is there a nice way to make this possible?

Thank you in advance.

Solved Solved
0 8 559
1 ACCEPTED SOLUTION

Workaround for this is to read values from the different table with the "Suggested value" and then have a validation that checks how many values you can select.

View solution in original post

8 REPLIES 8
Top Labels in this Space