In our organisation we prepare a number of different reports to different levels within the organisation. A lot of this information can be duplicated across different groups and levels.
I am wondering whether we could create a sheet to capture these reporting updates from teams, through direct entry into the sheet, or through forms, that is then collated through a filtering mechanism. ie a checkbox that filters what row updates and data goes into what report, and to which group.
It seems like it could work quite simply conceptually. However in practice it is a little more complex.
For example our reports include pictures/graphics in relation to the updates. And the formats are standardised across the organisation based on topics/activities/groups.
Ideally I would like to have one source of report information in smartsheet, and then have a report based on filtering information is created. But the formatting is nicer and it brings through pictures from attachments.
Is this possible at all? Has anyone developed anything like this for cross organisational reporting that is not based on metrics, rather written updates?