How do I do some data validation dropdown items can be selectable by only owner of the document?

Question

I have a Google Sheets document which is shared with nearly thirty people and I added data validation dropdown to all the cells to not entering different values except I defined.

This data validation dropdown has nine items and I want to the fifth, sixth, seventh, eighth and nineth items can be selectable by only owner of the document. Can you please explain how I can do this?

Answer 1

Google Sheets doesn't include a built-in feature to limit who can select certain option from a data validation drop-down but you might extend Google Sheets by using Google Apps Script more specifically by using an on edit trigger, it might be a simple or an installable trigger.

To use Google Apps Script you should know the basics about JavaScript.

Resources

• https://developers.google.com/apps-script/guides/sheets