I made a sheet for all my dropdowns in my for...

references
(Josh Lawrenz) #1

I made a sheet for all my dropdowns in my form and I’m using Valid_If to reference to that sheet.

The problem is that they are dependent on what my first answer is.

So,

if pick the first answer then all other dropdown questions are only giving me the answer for that row in my sheet.

I don’t what all dropdowns to be determined by the answer of the first dropdown.

What am I doing wrong?

(Aleksi Alkio) #2

You are probably now using TableNAme[ColumnName] formula. It’s okay in the first one. For the next field and so on, use SELECT(TableName[ColumnName],TRUE) instead.

(Josh Lawrenz) #3

Yep… Thanks