Placeholder in automated email of sheet name?
I would like to be able to include the sheet name in a time based update automation which is a part of a template set. While we could make it a part of the set up process to update this automation manually with each new project, ideally we could just insert a placeholder for {{Sheet Name}} and have it fill in. This would be true for sheet summary values too. Is this available and I am missing it, or is this in the works by any chance?
Answers
-
Hi @CBlass
You're not missing anything, its a great idea!
One work around, which still requires a manual update if not using Control Center, is to fill in the Sheet Name in the Sheet Summary and then reference that field in a column on the sheet by using =Sheet Name# in the column to pull in Sheet Summary information. Then you can use that column information in the automation. I usually do this for the Project Name and not the Sheet Name but it would work the same.
The benefit here is that you'll have the Project Name / Sheet Name column available for all the rest of the automations and stacked reports. Sometimes the Project Name is more preferred for stacked reports if the report is made from different sheets within the same projects across the portfolio.
I hope that helps.
Matt
-
Would you like to see this feature added to Smartsheet as much as I would? Upvote it in this feature request thread: https://community.smartsheet.com/discussion/110609/reference-sheet-name-in-formula?_gl=1*6kyknu*_ga*OTY0MTg3OTIuMTY5MjE5NzA0Mw..*_ga_ZYH7XNXMZK*MTcxMTYzMzI2OC4xMjAuMS4xNzExNjMzNDQ1LjYwLjAuMA..
