Email automation with PARENT/CHILD data from pivot table
I'm trying to create an output of specific rows of a pivot table to attach/include in an automated email. See below for an example table I'd like to extract from the master pivot table.
The "Alert someone" automation allows me to specify which cell information I want to include but does not seem to be able to allow for Parent/Child relationships in the pivot table. When I used the {{ }} approach it default to the PARENT row but did not output the CHILD rows. Is this currently possible in smartsheets or am I going about this the wrong way?
Thanks,
Shannon
Best Answer
-
Happy to help!
You can set that up in that option. (see below)
Would that work?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Have you thought about a dashboard instead to display the information in a nice chart?
Ken Armstrong
Smartsheet Project Manager, GE Aerospace
Certified Smartsheet Administrator
Be Firm! Be Fair! Be Friendly! Be Honest!!!
-
@Ken Armstrong I would consider it. Would the dashboard allow me to send an email to specific contacts so they can only see their specific row data but not other data from the Master pivot?
-
@ShannonL Unfortunately not. Dashboards are more for displaying data for teams or groups. Its a bit time consuming at first but maintains it self if you were to create a dashboard per person you want to display the information. I do this with KPI tracking for employees.
Ken Armstrong
Smartsheet Project Manager, GE Aerospace
Certified Smartsheet Administrator
Be Firm! Be Fair! Be Friendly! Be Honest!!!
-
Hi @ShannonL,
Dashboards are a nice way to display data. I agree with everything @Ken Armstrong mentioned.
Depending on how many contacts you have, an alternative might be to create unique report for each contact and set up to send as an attachment. There are limitations to this but you could set it up to send out on a weekly basis for a set amount of time.
If your contacts are all setup in Smartsheet, you could create a report and set the contact cell to "Current User" so that they would only see the row data that belongs to them.
Some of these solutions involve some Smartsheet magic to be done behind the scenes as an admin... but there may be a creative way to solve for this.
All the best,
🌻 Sandra
-
@Sandra Guzman Can you explain this in a little more detail? This seems like it could work.
When I'm in the report, I've sorted by Contacts and can see the information I need to send the contact. However, There is not an option to automate an email in the report only to send as attachment. How could this be automated?
Thanks,
Shannon
-
Hi @ShannonL
I hope you're well and safe!
Here it is.
Did that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks @Andrée Starå. I saw the option to send as attachment but that would require me to open each sheet to send that attachment. I am looking for way through the Automation Tab to do that on a recurring basis.
-
Happy to help!
You can set that up in that option. (see below)
Would that work?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Got it. Thanks.
-
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives