Google Sheet Notification for others

[Sarah Casper]

Hi all!

I understand that notification rules can be set for yourself for when changes in a shared doc occur.

I am curious how to set a conditional setting for a cell for when a specific change is made, THAT specific individual is alerted. For instance, a shared sheet has a column with a dropdown list of "NAME A" and "NAME B". When someone clicks on that dropdown and chooses "NAME A", I would want them to get the alert that a change, or more appropriately an assignment, has been made concerning them, not me.

TIA!

[Keith Andersen]

Use an onEdit function to get the changed cell then have it send an email notification to the specified person based on the cell range attributed to that person.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/65cadb08-c082-4300-a08a-07109006782cn%40googlegroups.com.

[Sarah Casper]

Thank you. I am pretty new to this type of coding. Do you have any tips on how I could find the correct code for this?

[Keith Andersen]

Yeah sure. Let me work up an example. Are you familiar with app script code and the editor and such?

My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/f46ef7cd-50a5-4587-8ce0-668c25c56b8bn%40googlegroups.com.

[Sarah Casper]

No, Just learning now for this project for my team. Thanks!

[Keith Andersen]

No problem. I'll work up an example worksheet with short video explaining how it works and how to implement it. You can then decide if it can meet your needs.

However, I'm on short vacation. I can have something by next Thursday if that's ok?

Keith

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/45dc61fd-09ad-4ed7-8f58-6bbdc5627afen%40googlegroups.com.

[Edward Friedman (Eddie)]

This can now be done without coding using the newly released Conditional Notifications feature. It can be found under Tools>Conditional notifications. If you don't have access to it yet, you should have it by the second week of July at the latest.

I thought I had seen a writeup on the new feature, but I can't seem to find it. Here is a link to the feature description on the Google Workspace Updates blog

https://workspaceupdates.googleblog.com/2024/06/conditional-notifications-google-sheets.html

[Keith Andersen]

Awesome Edward! I'm looking forward to that for sure! 👍👍

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/25093ad4-48e9-4006-b7f3-b42359937d42n%40googlegroups.com.