View Ranges Used in a Sheet (or all sheets)

Kate F.
Kate F.
edited 12/09/19 in Formulas and Functions



I would like to know where I can go to make edits to some of the ranges I created.  Normally, I can see the ranges I have created by just clicking on the cell once (rather than double-clicking to edit), but my formula is too long and it pushes the range links off the page.  Please see attached screenshots.

Any help you can provide would be very much appreciated.



2018-09-17 14_28_49-TCO Project Schedule - New - DRAFT - Smartsheet - Range Links Pushed Off Page.png

2018-09-17 14_29_27-TCO Project Schedule - New - DRAFT - Smartsheet - Formula with Ranges.png


  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    I copy / paste long formulas to my editor of choice to make edits and then copy them back.

    To update X-Sheet References, in a spare cell somewhere, I use something like

    =COUNT({the current reference})

    and then I edit that reference using the formula aide. 

    Changes will be reflected for that reference everywhere on the current Sheet (name and/or range)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!