Importing/Syncing Excel File

smarterwithsmart ✭✭✭
edited 12/09/19 in Formulas and Functions

I have created some sheets that reference a master sheet. This master sheet was populated by importing an excel file. The data in that excel file is generated from a web page that exports to excel and is constantly updating. I'm seeking a solution to be able to update my master sheet. Importing doesn't work as it creates a new sheet and my formulas won't reference the new sheet. Copying and pasting doesn't work either as I'm over the 500 row limit.

Any ideas on a solution?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!