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
Check out the Formula Handbook template!