Column Lockdown

I have a Sales Report that I have filtered a Column that contains the Regional Managers in this report. The Filter is so I can view the Data only for a particular Mnager and also this is what I would like them to see also is just their Sales portion and not the other Managers. When I filter for them, and share to them as a Viewer only. They can still remove the filter to see the other Managers Sales Data. Without copying each Managers Data to a separate Sheet, how can I lock down this column for each individual? Or is this possible?

Find more posts tagged with

Sales

Finance

Security

Comments

Matt Hagler

Greg,

It sounds like you may want to make a report for each manager that has parameters similar to what you have set up in your filter. Share the report with that particular manager and you should be off to the races.

Sign in to join the conversation!

Quick Links

Trending discussions

Blank rows appearing on the bottom of Report and embedded reports
I have a report that will generally only have about 15 rows on it. I see in other threads that Smartsheet will automatically create enough blank rows to reach 50, or at least 10 blank rows always at the bottom. Even if I delete the blank rows from the Sheet (which has hundreds of data rows), they reappear the next time I…
Automating Quarterly/Annual Reminders
I need to setup automations based on a contract date that will notify me on a monthly/quarterly/annual basis so I can process paperwork at the appropriate time. Ideally, I'd like to set it up to send an email 90 days before that date. I have columns for the initial contract date and the frequency (one for the word…
Set Dashboard as Default Homepage for All Users
Hi everyone, Is there a way to set a dashboard as the default homepage for all users upon login? Ideally, we’d like users to land directly on a particular dashboard instead of the usual default page. Is this possible through configuration, or is there a plugin or workaround that can help us achieve this? Thanks in advance!