Linking Smartsheets to Excel

Is there a way to link Smartsheets to Excel. I have a sheet in Smartsheets that I need to populate with the current months actuals each month. The actual data for the month is summarized in the same file each month. Instead of keying in the data each month or trying to copy the data I was hoping that I could establish a link or lookup that would update the information each month. I have the months going across the top the projects down the rows. In a month a project may not have actuals. The data in the future months is forecast data that should be overwritten when the current months actuals are available. Is this possible to import or link the current months acruals into the sheet?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!