Add new value in edit mode

Hi All,
I have this expression to switch data validation sources depending on the selected category.
[Material Category],
(LIST() + Steel[Steel]),
(LIST() + Wood[Wood]),
(LIST() + Adhesive[Adhesive]),
(LIST() + Electrical[Electrical]),
“Bolt and Nuts”,
(LIST() + Bolt and Nuts[Bolts and Nuts]),
(LIST() + Plumbing[Plumbing]),
(LIST() + Fastener[Fasteners]),
(LIST() + Mason[Mason]),
(LIST() + Paint[Paint]),

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?


Use Suggested values rather than Valid If.

1 Like

Hi Steve,

1 Like