Hi All,
I'm creating a data validation source list linked to a name =FG.
The name "FG" definition is an unique list created by the following function: =SORT(UNIQUE(FILTER('FCST BW'!$P:$P;NOT(ISBLANK('FCST BW'!$P:$P))*NOT(ISERROR('FCST BW'!$P:$P)))))
It basically includes only unique names (not blank and without errors) and sort them a to z from a selected column "P", the result string is correct with the classic format: {"a";"b";"c" .....}.
when i'm trying to add the name in a data validation it returns the error "the source currently evaluates to an error".
Any Guess on how to solve it?
Thanks!
I'm creating a data validation source list linked to a name =FG.
The name "FG" definition is an unique list created by the following function: =SORT(UNIQUE(FILTER('FCST BW'!$P:$P;NOT(ISBLANK('FCST BW'!$P:$P))*NOT(ISERROR('FCST BW'!$P:$P)))))
It basically includes only unique names (not blank and without errors) and sort them a to z from a selected column "P", the result string is correct with the classic format: {"a";"b";"c" .....}.
when i'm trying to add the name in a data validation it returns the error "the source currently evaluates to an error".
Any Guess on how to solve it?
Thanks!