Replacing sheet data regularly to update dashboard

Geraldine Ahsue
edited 06/29/22 in Smartsheet Basics

Hi all,

How can I replace large swaths of data in a sheet regularly, and preserve its sheet summary functions so that the dashboard will reflect the new data? Is there a way to import an excel sheet directly into a preexisting sheet? Cut and paste is not an option as there is too much data.

Thank you for any insight or advice you can share!