Report erasing data in a sheet
I have a report running to track changes across multiple sheets. When data is added to the sheet, I see that change in the report as expected. However, when I remove data from the report, it also removes data from the sheet that it is looking at. Is there a way to prevent this? I do not want to remove data from the report and it remove that same data from the sheet.
Answers
-
Hi,
Changes to data in a report will always be reflected on the source sheet as they are connected in real time. There is currently not a way to make changes to data on a report without affecting the source sheet.
You may want to consider adjusting the filter criteria of your report so that it filters out rows from the report based on certain conditions, instead of removing data from the report that affects the source sheet.
Hope this helps! Let me know if you have questions.
Best,
Mike
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives