Reference sheet name in formula.

It would be nice to be able to put something such as @sheetname or {{Sheet Name}} or something to call specifically to the sheet name for a formula. This would make it easy for sheets to be duplicated across vendors/products without having to change anything but the name of the sheet itself.

Sign in to vote!

Find more posts tagged with

On Radar

Comments

Matt Rasmussen

I upvoted this suggestion because I would like to use {{Sheet Name}} (or whatever naming convention) in automation workflow email notifications. For example, the email subject field could be "{{Sheet Name}} item assigned to you" for when an owner is assigned an item in a RAID log.

This would prevent having to change the sheet name in every workflow when we use our templates. Right now, we have to update each workflow manually before sharing the sheet to the team.

I see some workarounds being suggested in the community with hidden helper columns or sheet summary fields storing the sheet name, but those clunky workarounds still require someone to enter the sheet name into those fields. This feature request would eliminate that. 👏

BarbaraGriffith

I voted this up as well in order to get the sheet name automatically included in the workflow message. This shows up in the message if we use the notification coming from Smartsheet, but if we customize the message to come from our organization, that information no longer shows in the message and there is no way to get it back.

RobJagger

I'm trying to build automation to request updates from assignees. Getting 2 emails with subjects of "Project update needed" without any context will lead to confusion and accidentally updating the wrong sheet, specifically since the update form also doesnt show any context. A message subject like "{{Sheet Name}} update needed" would be incredibly helpful

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Editable email Subject header from Smartsheet Notification
Hi There, I would like to propose that Smartsheet considers the email subject header that is received from a Smartsheet notification from a form or sheet. Currently, because not everyone in my company has Smartsheet, let alone a Smartsheet log-in, we need to send show the name of the owner of the sheet, that appears on the…