How can I access the name of a sheet in a formula?

we have the convention where particular series of sheets start with "YY_XXX9999_etc" where the YY is a overall Project code and the XXX9999 is a code for the location where tasks will be done. I want to extract the code from the sheet name and use it to populate the sheet with additional information from a master list of locations. Is this possible? e.g. =MID({SheetName}, 2, 7)


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You would need to leverage the API or the premium add-on Bridge to accomplish this.

    Otherwise you would need to manually enter it (probably in a sheet summary field) and then reference that, but you would have to remember to manually update the field if the sheet name changes at any point.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!