nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Open sheet with a filter and deactivate the option to set filters

Peter

Hi there,

is it possible to open a sheet with the unique url (maybe out of a sight or the intranet) and set a filter plus deactivate the other filters. Maybe with parameter in the url?

many thanks

peter

Find more posts tagged with

Sheets

Dashboards

Comments

Richard Rymill SBP

Peter

IF you are happy to Publish a Report with a Unique URL then by using the Queries and filters that Smartsheet Report provide, I suspect You can get very close to what you seek?

That also takes away the need for the viewer to see the background sheet but they will not be able to edit it?

Or you could publish the sheet itself but that may be less helpful?

OR Maybe use a Dashboard to show what you wish with Live links for potential editors/ updaters?

Hope that helps?

RichardR

SBP

Peter

Thank you,

the problem in reports is that they don't calculate if ther are changes. You have always to save and refresh ...

I want to calculate a sumary over different sheet (with references) by filling one cell. For intsance: Ordernumber ... how many trucks calculated by weigths of elements ... different sheets for how much on a Truck, different Elements and so on ... no problem in a sheet but lot of rows vor calculation. With report it will work but not very nice ...

hope you understand my bad englisch :-)

Sign in to join the conversation!

Quick Links

Trending discussions

If someone has multiple rows where their contact appears, can they just receive one email?
Hello, I'm trying to not spam the people I need info from. I have 600 courses and need the course owners to fill in some info for me. Some people are the contact for 30 courses. If I just send an automated request for an update, they'll get 30 emails. Can I automate an email so that each contact just gets one request if…
Users unable to update CheckBox
I use Smartsheet for our audit process. It has worked wonderfully all year but a new set of audits just came in and for whatever reason my team has lost the ability to check the completed check box in the sheet. I have checked to make sure the column is not locked, upgraded their permissions to admin. No luck. Screenshot…
is there a way to have more colors available in sheets as in dashboards?
hi, When customizing dashboards, I notice that there are more options available to choose or create color combinations compared to the static color palette that appears in sheets. Do you know how I can include more colors in sheets, similar to what is available in dashboards?