How to create a searchable and printable report that is public?

Hello,

I have a Diversity inventory that contains a list of different programs managed by different departments. Now we are being asked to publish that inventory in a way that is searchable and printable. This should be public, meaning that people don't need to login to Smartsheet to view the data.

I thought of using a dynamic view, but can I publish a dynamic view?

If dynamic view is not the solution, is there a way I can create a report where people can use a Seach function (not filters) and also be able to print a set of data?

Is this even possible in Smartsheet? All ideas are appreciated.

thanks!

Ivonne

Find more posts tagged with

Sharing and Collaboration

Integrations

Accepted answers

Genevieve P.

Hi @Ivonne Mejia

I've answered your other post (here), but I'm happy to clarify on this post as well.

No; only the report Owner or Admin shares to the Sheet(s) and Report can create filters on a Report since this would be updating the Report Builder criteria. Please see the Help Center article on Sharing Permissions at the bottom, here: Sharing Permission Levels.

As an alternative, you could set up multiple reports with different possible filters, then provide these multiple URLs as filter-options to your end users instead.

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Ivonne Mejia

If you are on a business or enterprise plan, you can use the Publish feature to do exactly what you describe above.

You can publish a report to display it in a view-only format that allows viewers to open row attachments and comments, highlight changes, and print the report. Viewers can also use the "Find" feature, Ctrl + F (Windows) or Cmd + F (Mac) to search through a published report or sheet. See this Help Article for more information: Publish a Sheet, Report, or Dashboard

Cheers!

Genevieve

Ivonne Mejia

Thanks Genevieve. Is there a way for end user to filter rows from the report and print those rows?

Genevieve P.

Hi @Ivonne Mejia

I've answered your other post (here), but I'm happy to clarify on this post as well.

As an alternative, you could set up multiple reports with different possible filters, then provide these multiple URLs as filter-options to your end users instead.

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.