Feature Request: Programmatically access parent information from child in automated messages

A lot of the users consuming my automated alerts complain that the tasks don't have enough contextual information. For instance, "start marketing research" doesn't include the parent information of "Awesome Campaign #3".

Need a way to include parent information in automated messages.

For example,

"Hi {{Assigned To}}!

The below task is starting in 3 days! Get ready!

Project: {{Task Name}}.Parent(Task Name)

Task: {{Task Name}}

nick g

Find more posts tagged with

Formulas

Comments and Conversations

Enhancement Request

Email Notifications

Comments

Andrée Starå

Hi Nick,

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

Please submit an Enhancement Request when you have a moment.

As a workaround, you could add a so-called helper column that would get the parent row for all rows and reference that.

Would that work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Mike Wilday

Once you create a Text Column you can call it Parent then enter the following formula... =Parent([Name of Column]@row)

Make sure to substitute "Name of Column" with your own task column and you should see the parent name appear.

Mike Wilday

See screenshot for more information:

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.