As work gets more complicated, and you're capturing more data from different sources, working across multiple sheets becomes the norm. Yet connecting data across sheets can be a challenge, especially when dealing with large sets of data. Today, we're excited to announce that we've added cross-sheet formulas to Smartsheet - including VLOOKUP, one of our top customer requests.
Cross-sheet formulas fundamentally change the way you can manipulate data in Smartsheet, giving you more flexibility and power to create connections across all of your team's work and information, regardless of what sheet that data is in.
Instead of repeatedly entering the same data into multiple sheets, or manually searching through large sheets to copy and paste or create cell links, you can enter a formula once at the top of a column and copy it into the column's other cells.
Additionally, when you add a new row, cells will be autofilled with the appropriate formulas. This is particularly powerful on a sheet being populated by a form, as the lookup formula information will be added to new submissions without the need to constantly monitor the sheet.