1

(I think protect sheets/range will help here but besides that.)

Let's say I have a sheet called Alcohol that imports from other sheets Tissue, Pencil and Physics and is editable by other users.

How can I be notified only of edits to Alcohol by other users and not edits due to IMPORTRANGE updates from Tissue, Pencil or Physics?

or

How can I be separately notified between indirect edits to Alcohol due to IMPORTRANGE updates and direct edits to Alcohol due to other users?

It seems (assuming no Google Form -- well I assume user submits a form refers to Google Forms...?), we have only:

Set notification rules

daily digest or right away for any changes made.

I would like immediate notifications for any changes made by users but not right away for any changes made through IMPORTRANGE.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.