Will inserting a new column break references?

Rob Wright

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?

Heather Duff

@Rob Wright,

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