Adding a Column in a Cross Sheet Reference Range on VLOOKUP
I'm exploring changing several of my more complex Smartsheets to rely less on links and more on data tables that are accessed by other sheets using VLOOKUP functions. Everything was fine until I needed to add a new column on one of the data tables and discovered that the named ranges that use that table don't automatically update to account for an additional column in the middle of a range as I expected, or at least hoped. In other words, it looks like I need to go edit every VLOOKUP function that references columns to the right of where I inserted the new column and add one to the column number to retrieve the desired data.
Maybe one of the Smartsheet support people can verify that this is how it's supposed to work. I suspect that the ranges are associated with the sheet that uses the VLOOKUP function so it has no idea that the external reference range has changed. Links appear to be based on cell-to-cell connections so inserting new columns, moving columns around or moving rows up and down doesn't impact them.
Help Article Resources
Check out the Formula Handbook template!