I love that we're now able to use ranges from other sheets in formulas. I just updated a summary sheet so it uses formulas linked back to worksheets for each member of my team, rather than having the formulas on each team member's sheet and linking from there.
I have a couple of questions about the best way to use the new feature.
1) I named a set of cells on a sheet I was linking to, and then decided I wanted that name for a different set of cells. I renamed the first set of cells, and then tried to use the name for the second set. I got the message, "This name is already being used on this sheet. Please enter a different name."
Is there a list of named cell ranges that I can access, so I can delete a range name if necessary?
2) In using this feature to create a summary sheet, I wanted to copy a formula so I could apply the same calculation to a worksheet for each member of my team. I created a formula referencing cells from one team member's sheet, copied it into a new cell, and updated the cell ranges to link to a second team member's sheet.
When I did this, Smartsheet changed the links in the formula for the first team member to link to the second team member's sheet (i.e. so both formulas link to the same "outside" sheet). Can I prevent this from happening?
Thanks,
Jen