Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Reference Sheet name in a Formula within a Sheet

Options
sedk
sedk ✭✭
edited 12/09/19 in Archived 2017 Posts

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.

Comments

  • Shaine Greenwood
    Options

    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
    sedk ✭✭
    Options

    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.

    Capture.PNG

  • ker9
    ker9 ✭✭✭✭✭✭
    Options

    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
    Options

    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
    J. Craig Williams ✭✭✭✭✭✭
    Options

    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

This discussion has been closed.