Protection Conditionnel in Google Sheet

Fermé
Rachide - 18 oct. 2018 à 20:24
I use Google Sheets to manage orders, and Share it with my team Exemple:

https://docs.google.com/spreadsheets/d/1Hy8lIALMVhV2rpws3Ltd8w3gLKZtg4sZB_vaW7X9tKA/edit?usp=sharing

My question is: I want to Lock "No one of my team can edit the status and date range" after he put that the order is Delivered or Cancel Meaning when Status is Delivered or Cancel but everyone can edit if Shipped or No answer untill the order is delivred or cancel then lock the range

Please if any one can help me to get script for this

thank you
A voir également: