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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!