Jan 14 2023 12:01 PM
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
Jan 14 2023 12:55 PM
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.