Range name

Hi everyone,

I have a question about the range name and description.

When I use formula with another sheet it calls automatically like {range Count}.

Later, when I try to find out, which sheet data is being used in the formula, I can't find the sheet and range because I just forgot it and it is not mentioned in the range name.

Could you please share with me whether it is possible to find the description of the range in { } somewhere?

For example: {range Count} = sheet "Name", range "Count:Count"?

Thank you!

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 04/10/19

    Hi Kseniya,

    The only places where you can see the reference is in the formula, or when you click on a cell, that's part of the formula. If you click on the links "Edit Reference" you'll open the "Reference Another Sheet" window where you can see and update the range.

    It's also a best practice to rename the references to something better, so it's easier to work with.

    1. You can optionally type a name for your reference. (If you don’t enter a name, the reference will be assigned a default name based on the sheet name and the number of times that sheet has been referenced.) 

    Hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Thank you, it has really helped! :)

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Excellent!

    Happy to help!

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    I rename all of my references to "Sheet Name - Column Name" unless the range is not an entire column. In those cases I will use something specific to that range such as Row Number or even "Sheet Name - [Column Name]#:[Other Column Name]##".

     

    If I am getting errors in my formulas I will use what Andree suggested and click on the "Edit Reference" link. When the sheet comes up, it will have a bold box around the range so you can make sure you actually selected the correct cells.

    thinkspi.com

Help Article Resources