Producing automated reports with select info for weekly sendouts


I am trying to prepare reports that show certain information (eg, here are all the things that have happened in the last week/month/are coming up etc).

If I do it as an automation in smartsheet, I cant seem to link certain columns without a linking the whole sheet (which contains sensitive information).

In reports, the only way I can see is to send as a PDF rather than something that can be just read on screen.

Dashboard see above. I will have a dashboard linked to the email, for more detailed info, but how do I sort an automated email that can be distributed without linking all the sheet and data?

Many thanks!



Best Answer