How to automatically include project names in automated update requests and forms

Hi,

I have several projects that follow the same breakdown structure, when Smartsheet sends automated update requests, users are receiving these notifications don't know which specific project the request is referring to.

I noticed that the project name is not an automatically included in all update requests for different projects. Is there a way to ensure that the project name appears not only on the email but in the update form so the user knows exactly which project they are updating.

I tried doing this manually on specific projects sheets and the automations, but it does not work or I get an error. The goal is to find a solution and get a global update to all projects and have each request and form state the project each user is updating.

Find more posts tagged with

Forms

Project Management

Workflows in Smartsheet

Email Notifications

global updates

Accepted answers

AravindGP

Hi @LuRam

You can add a column to your Project Plans with the name Project Name and add it as a formula ="Name of Project" and make that a column formula. The value will get updated to all rows which have data. Once done, you can include this field in your update requests. Since it is a column formula, the value will show in the update request form as a non-editable field.

All comments

AravindGP

Hi @LuRam

LuRam

Thanks @AravindGP

It worked!

AravindGP

Hi @LuRam

You will need to add it to the list of fields being sent. If you want the email subject to include the Project Name, you will need to enter it in the subject/body in double curly brackets as shown below

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.