Adding columns to a sheet that feeds info to other sheets
I have a master sheet that houses quite a bit of info pertaining to projects. I have been asked to add new columns to the sheet however, this sheet feeds an "intake sheet" which feeds into other project specific sheets. If I add columns to the master sheet, I believe this will mess up the current information in the intake sheet that is coming from the master sheet and bring back the wrong information. Is this correct? If so, short of adding columns to the end of the sheet, how can I fix this and avoid this in the future?
Best Answer
-
Not with a VLOOKUP but INDEX/MATCH provides a lot more flexibility in the source data.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
It depends on how things are being brought into the other sheet(s). Things like VLOOKUP most likely would be broken unless you insert new columns on the far right of the sheet, but cell links and most other formulas should be ok generally speaking.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Can I not set the parameters with the column names as opposed to column number?
-
Not with a VLOOKUP but INDEX/MATCH provides a lot more flexibility in the source data.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
ahhhh.... ok gotcha. I'll look into that then. thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!