Email daily comments on (multiple) sheets

Naiche

This seems pretty basic, so not sure if I'm missing something. But, certain project stakeholders like to receive daily status emails that show the project activity. When I say activity, I mean comments, not who changed which cell. Currently the only way I've been able to do this is the literally grab screenshots of the comments from the comment pop up window 1, 2 or 3 at a time. I'm unable to copy and paste the text from this pop up. I would use the export function, but the comments are not given any context, so I'd have to see if I could build an excel template that I could paste into and perhaps it would do some vlookups. I may have to go this route. But, seems strange that there is no easy to just grab the comments for the day and put them into an email. 

Thoughts?

Naiche

(bump)

Andrée Starå

Hi Naiche,

Unfortunately, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Happy Holidays & Happy New Year!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

RunningMatters

Hi Naiche, what I do is enable Slack which sends an automatic record of any comments that are added to a sheet.



You could tailor this by setting up a specific stakeholders group on Slack and adding the people to this group. Slack would then give notifications of any comments added.



Hope that helps.

Andrée Starå

Hi Sean,

Great workaround! Thanks! 

Happy New Year!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting