Project/Sheet Name in subject of Alerts/Request/Reminder

Hi everyone,

I have a team managing several projects (80+) at a time. I have setup alerts, reminders etc for each project.

So the same people will get alerts for different projects.

How do I incorporate the project name (which is the sheet name) in the subject of those alerts so it is easy for the team member to know for which project he/she is receiving the mail?

Manually setting it up for each project is not possible.

Thank you.

Find more posts tagged with

Update Requests

Email Notifications

Accepted answers

All comments

Genevieve P.

Hi Abhiraj,

If you have not set a customized subject line, the subject for an alert that is immediately triggered when a change is made will be "Changes to Sheet Name." The sheet name will also be included in the body of the alert, at the top of the email with a link to the sheet that it is referencing.

If you have set up a customized subject line, you will need to include the sheet name manually to each alert/workflow.

Should this be different than what you're experiencing, it would be helpful to see an example screen capture of the types of workflows you have set up, along with a capture of your sheet (but block out any sensitive data).

Thanks!

Genevieve

Abhiraj Joshi

Thank Genevieve.

I added a helper column with client name and used {{ }} to include it. It has solved my issue.

Genevieve P.

Glad to hear it! Thanks for letting us know about your solution 🙂

Justin Silva

I would like to raise this as an enhancement request. It would be very useful to be able to recall the sheet name using the {{FIELD}} function, without adding a column to the sheet. As in Abhiraj's situation, I too have dozens of projects occurring simultaneously, and this context is useful to the actors in update requests.

Andrée Starå

Hi @Justin Silva

Great idea! That would be a great addition to Smartsheet features.

Please submit an Enhancement Request when you have a moment

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.