Importing Excel file to Smartsheet

Hi All,

I have an excel file that I imported to Smartsheet - I have built a dashboard based on this report and it all works great. The issue is, as it is an extract from one of our customer's programs, we get this on a weekly basis, which means I will have to upload it to Smartsheet weekly. I don't want to build a new dashboard every week to represent the up to date data. Is there a way to bring a new report on to the existing sheet so the dashboards gets automatically updated?

I have tried the file - import from excel function but it seems it's creating a new sheet every time I tried. Copy and paste is not really doing it for me either as it's only allowing 50 cells and the extracts are much bigger.

Do you have any other ideas please?

Answers