Is it possible to select formulas in a data validation list?
The list I am trying to create is something like: =roster1, =roster2, Day Shift, Night Shift.
roster1 & roster2 are names for formula that I would like to enter into a cell via a validation list. However, each time I try to create the validation list I receive an error message stating that my formulas are incorrect.
Any suggestions?
Bookmarks