Reference Sheet name in a Formula within a Sheet

I've seen a similar request for referencing the parent Workspace (though I didn't see an answer) but I am interested in referencing the name of the actual Sheet in a cell within that sheet.

I am planning on auto-filling some of the task names within a sheet with a name from the first task row (this would be the overall report name) that I want to auto-fill from the name of the sheet. I want this so when the specific tasks show up on the calendar I can know which report it goes with without doubling the work.

Find more posts tagged with

Sheets

Cell linking

Comments

Shaine Greenwood

Hello,

You'll need to place a formula with the sheet name in the Primary column for this to show up in your Calendar event task bars. This formula will autofill down the Primary column as you add new rows in the Grid/Gantt Views of the sheet. You'll want to put the task name in another column.

Here's an example of what this formula might look like:

="Construction Project Sheet" + [Task Name]1

You'll need to manually enter the name of your sheet between the quotes.

This is the only way to get text to auto-fill down the sheet automatically for you as long as it exists in the Primary column in two cells above or below. Otherwise, you'd need to manually type in the name of the sheet in each cell in the Primary column.

sedk

Shaine,

Thanks for your response. This is actually what I am doing already. I fill in the very top row for the Task as the name of the report which then auto-fills the rest of the tasks with the report specific name.

However, I was looking to see if there was a way to auto-fill that first task row with a pointer to the actual sheet name so that I wouldn't have to type the report name as the sheet name as well as the first task row.

In the picture below, I want the REPORT NAME cell to be auto-populated from the Example Template v4 name of the sheet.

Though it looks like this isn't possible.

ker9

I'd like to add my vote for this functionality. I would like to use the Sheet Name in a formula that can be copied and inserted into an update request or reminder as text for the message (and not have to manually enter it for 7 reminders).

Furniture27

I am currently running a trial version and this feature is essential to how we want to use the system. Is it likely to be added any time soon?

J. Craig Williams

This feature was added recently, which helps some of my use cases:

https://community.smartsheet.com/announcement/dynamically-customize-alert-and-request-messages-placeholders

Smartsheet does not take requests directly from Community Posts, you can do that here:

https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409

Can you describe how you would use this outside of Alerts?

Craig