Notify someone
Hello,
I have a sheet that is updated on a daily basis using the "comment" feature. I have a manager who needs to be able to see the line items that are not updated that week. Since the only field that is being used in the sheet by the user is the comment bubble, how would you notify the manager?
Answers
-
The way I would do this is to set up a Record a Date workflow, so that whenever a comment is added to a row it updates a Date Column in your sheet:
Then you can either create a Filter on the sheet based on the Date Column not being Today, or create a Report.
You can also set up another Alert/Notification workflow to send the manager a Daily email with all the rows that don't have Today's Date:
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives