Range name

04/10/19 Edited 12/09/19

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 PARTNER & CONSULTANT / EXPERT

    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 PARTNER & CONSULTANT / EXPERT

    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 NewcomePaul 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

Sign In or Register to comment.