I want to know if I should be able to do this as a Data Validity formula:
I was expecting to get a one row dropdown with the value ‘Manage Events’ - which I get as a value if I use this:
offsetFrom is a named one cell range which is a cell on another tab; I have tried changing the formula to use the cell reference but it still doesn’t behave as I expected.
This is part of a bigger scenario I was attempting but if I can’t use OFFSET in this way I need to rethink? Or is there another problem I have missed?