A User of Magic Cell Notifications
February 5, 2019
Is there a way to have a notification stay anchored to a specific value based on the the information on a row and a column, so that if the sheet is sorted that the notification stays attached to the original information?
For example: If I have a sheet with "Brandon" in Cell A3 and a function in column B, and I want a notification when Cell B3 = 30 (e.g., Brandon is 30). But if I needed to add more data (e..g, Adam to column A) now Brandon's info would be pushed down to A4, but the notification wouldn't be pushed down. So anytime I add more data I have to redo all the notifications.
Is there a way for this not to happen? I hope that made sense.