Will inserting a new column break references?
I think I know the answer, but my colleague wants a little more reassurance;
She has a data sheet, and this data sheet feeds a number of single cell reference metrics to a dashboard. She wants to add a new column of data to the initial sheet, but is concerned that it will break the references the metrics use.
I hvave advised that as Smartsheet utilizes column names in its references rather than a, b, c like Excel, that this will not happen. Is this correct?
Answers
-
You are correct - the links will not break when you insert or rearrange columns or rows. It will even update the links automatically if you rename the column names.
If she's still not trusting of it, have her create a new sheet and dashboard and play around with inserting and rearranging rows and columns and renaming the columns on the source sheet. That way it'll show her that it won't break the widgets on the dashboard.
Hope this helps!
Heather
-
Many thanks Heather!
-
Hi @Rob Wright
I hope you're well and safe!
To add to Heather's excellent advice/answer.
It depends on what kind of reference/formula it is.
If it's a VLOOKUP, it could break it.
Make sense?
I hope that helps!
Be safe and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå Thank you for adding that! I rarely (if ever) use VLOOKUP, so that fell off of my radar. I appreciate it!
-
Hi guys,
i think she is just pointing to cells in the metrics sheet using the metrics widget.
it makes sense about the vlookup, as smartsheet still refers to the results column as a number relative to the lookup column, but in any case I think I will be using index and match in the future in preference to lookups, as I recently came across issues with the 100,000 cell reference limit in smartsheet.
Thanks for the advice guys! very useful!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives