Changing Primary Columns
I have a number of smart sheets that all 'talk' to each other, and feed various dashboards and reports.
Slight problem in that the primary columns across them all are different - partly an oversight when setting them up, partly due to different people in the organisation setting up different sheets which I have since united.
I would like to unify them but as there are quite a few dashboards and reports fed from them I'm fearful of messing it up!...
When you move a cell, or selection of cells, it also adjusts the path that reports, dashboards, sheet summaries, and other formula etc is fed from, so my question is this...
Would it work if I:
- Insert a temporary column in to the smart sheet
- Move the data from the primary column into the temp column (hopefully also moving across all paths?)
- Move the data from the column I now wish to be the primary, into the primary column
- Move the data from the original primary column into the newly vacated space
- Delete the temp column
Any advice welcome and appreciated!
Help Article Resources
Check out the Formula Handbook template!