Hi All,
I have this expression to switch data validation sources depending on the selected category.
SWITCH(
[Material Category],
“Steel”,
(LIST() + Steel[Steel]),
“Wood”,
(LIST() + Wood[Wood]),
“Glue”,
(LIST() + Adhesive[Adhesive]),
“Electrical”,
(LIST() + Electrical[Electrical]),
“Bolt and Nuts”,
(LIST() + Bolt and Nuts[Bolts and Nuts]),
“Plumbing”,
(LIST() + Plumbing[Plumbing]),
“Fasteners”,
(LIST() + Fastener[Fasteners]),
“Mason”,
(LIST() + Mason[Mason]),
“Paint”,
(LIST() + Paint[Paint]),
0
)
it works well but I cannot add a new value should I cannot find what I need.
there is no “add” function.
thanks
Solved! Go to Solution.
Use Suggested values rather than Valid If.
Use Suggested values rather than Valid If.
Hi Steve,
thanks
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |