CrystalFacets
Technical User
I needed to create a listing that had a column with Data Validation (DV). Once someone selects from the column with DV, that selection is no longer 'available' for others to choose. This is accomplish using other formulas from a solution provided by a website (URL listed in the attached Excel doc).
The DV worked as expected after building and testing before uploading. However, once the doc was uploaded to Google Sheets for others to access, I noticed that DV no longer worked. The named range cell reference (includes OFFSET formula) was 'removed.' When I tried to re-insert it, I received a not valid message.
Any ideas how to make this particular DV operational in Google Sheets?
Thanks in advance for assistance. Again, file attached (pre-upload version).
The DV worked as expected after building and testing before uploading. However, once the doc was uploaded to Google Sheets for others to access, I noticed that DV no longer worked. The named range cell reference (includes OFFSET formula) was 'removed.' When I tried to re-insert it, I received a not valid message.
Any ideas how to make this particular DV operational in Google Sheets?
Thanks in advance for assistance. Again, file attached (pre-upload version).