Make Smartsheet More Powerful and Flexible with Cross-Sheet Formulas
Associated with
Dan Sills Dan Sills
3 min read
Make Smartsheet More Powerful and Flexible with Cross-Sheet Formulas

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.

More Ways to Read:
🧃 Summarize The key takeaways that can be read in under a minute
Sign up to unlock