Further to my database problem …
Here is what I tried to do: 1)
Used column B in sheet 1 to ref that column in sheet 2. - worked
Used column B as a deref in sheet 1 to pull in values from sheet 2 - worked
Requested to filter the contents of column B in sheet 1 by Category.
Added a Category column to sheet 1 just before column B in the spreadsheet.
I did this and it worked beautifully.
HOWEVER … the deref’s no longer worked.
Was I putting too much on the Column B?
Did you use the key column in your SELECT expression?
Hi Aleksi, to filter the contents of column B I did a column constraint
Valid If - and just the dependent dropdowns = sheet2[category] in the Category column and
sheet2[column B] in the column B Valid If.
User
clicks on Category and gets a filtered Column B list.
No
Select.
so… Sheet 1 Column B has a ref, a column constraint for dropdowns and an app formula for a deref.
Am I correct that it can’t have all 3 at the same time?
the deref seems not to engage once I added the column constraints.
Could someone tell me if having all three ref, deref and column constraint on the same column is a problem?
You can’t have all of them at the same time. You can use a ref field with Valid_If and deref if it’s on the initial value.
Thanks Aleksi.
You just confirmed my findings.
appreciate the help as always.
m.j.
Hi Aleksi , just to let you know, your question earlier about a SELECT expression got me thinking … so I
replaced the de-refs from 2 columns and used SELECT expressions in Valid IF to pull in the data from the from table in Sheet 2 .
Client gets all the functionality they requested.
Thank you.
m.j.
User | Count |
---|---|
63 | |
25 | |
14 | |
11 | |
6 |