Forum Discussion
A formula in a data validation drop down list
when i'm putting in a formula into the list of data validation its working accept if the formula have a comma for exemple =sum(1,2) than it will got split in the list like the pictures below
2 Replies
You cannot use formulas as individual entries in the Source text box, in particular if they contain commas, as you have found. They wouldn't work anyway.
HansVogelaar thanks!
.png){kind=link}
.png){kind=link}