Sharing a report without Sharing the Source Sheet

I saw this question has been answered several times but I am hoping that Smartsheet has introduced an enhancement. Is there a way to share a report without sharing the Source Sheet. I need the user to be able to edit/ update the report however there is sensitive information on the source sheet that will be filtered on the report.

Also, I am aware of Dynamic View. Will that work on this? How does Dynamic view work?

Answers