We have a system generated back order report that our planning specialist needs to run and distribute to 22 separate dealers twice a month. We do not yet have Data Mesh or Data Shuttle so she is still pulling the report manually from SAP into Excel. She then splits the data into 22 separate Excel files to email to each dealer.
I have set up reports in Smartsheet that automatically split the data and deliver it to the dealers from the uploaded SAP report. However, when I try to import data over the existing sheet, it just creates a new sheet which requires me to relink all the reports.
Is there a way to force the import to overwrite the existing data without the use of Data Shuttle?