Add new value in edit mode

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.


is there another way around it?

thanks

Use Suggested values rather than Valid If.

1 Like

Hi Steve,
thanks

1 Like