I'd like to send a weekly alert/action to remind each owner on the sheet to go into the sheet (not using a form) to make their updates. What's the best way to do this? Thanks!
I would recommend setting it up with the help of Alerts & Actions or with a scheduled delivery as an attachment of the sheet.
Which method would you prefer?
Have a fantastic week!
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
I'd like to generate some kind of alert. The email would ideally have a link to the sheet instead of a link to a form...
Recurring alerts are coming but aren' available today so I would recommend scheduling to send the sheet as an attachment or send a weekly report. It's possible to set up an alert to trigger, but it's more work to set it up.
Would that work?
What if I did it manually each week? I'm trying to get an email to generate for each person shared to the sheet that takes them back to the sheet and not a form.
There will be a link back to the sheet automatically included. If you'd prefer you could send it out manually, but it will probably be cumbersome because you would have to add the email addresses manually.
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, [email protected])
Sheet has been shared. I simply want to generate an email to each person shared to this sheet. It would serve as a weekly reminder for them to go into the sheet and to make their weekly updates on status, % complete, etc for the projects they own. Thanks!
I misread your question. If the users are shared you can manually email all users or set it up to be automatic. (I've also emailed you a screenshot)
Hi, Does anyone know if there is a way to send an alert if the value in a cell changes by more than a certain percentage? So, if I have 100 in a cell (text/number) and the value changes by over 5%, I'd like to be able to send an alert. Thanks, Vince
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.