This one is baffling. I have a problem with 2 sheets reading each others data through a Vlookup. Each sheet has Vlookup ranges from the other sheet. I understand why formula and Vlookup may return a #circular or #blocked reference, but …
Formulas and Functions62scott.barrett
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy.
I would like to have a form where someone selects one op…
Formulas and Functions2379Dajah
I understand there is an IOS app but it does not come close to the computer browser based environment, it doesn't perform as well, doesn't have matching capability, heck even the user interface is different. I do not care for the app but…
I was wondering if someone would be able to point me in the right direction as to how you can create a dashboard calendar that can be displayed for everyone who has access to see. This would be used for project management and to tr…
I am a sys admin in SmartSheet and need to have access to all sheets, workspaces, reports and dashboards shared with me. Do the individual owners of each of these need to share them with me or is there a way I can share them with myself a…
Using Smartsheet29Heidi Yablonski
I've created a few Dashboards and published them for viewing. After viewed, I removed the publish option in order to stop anyone from acessing them.
Is there a way to check all the Dashboards I currently have published?
I wanted to …
Using Smartsheet30Jose Vale
I have sheets that I want to notify a few people of changes. When I use the email to shared users function it will list all users shared to the workspace first and also users shared to the sheet. It would be helpful to see the list in na…
Using Smartsheet8Peggy Finley
I was wondering, is it possible to share a Smartsheet Report to everyone in the organization for editing? I'm using the 'Current User' Report parameter to limit what the user is looking at and what can be edited. But updating User G…
I'm working on developing a template workspace for our PM to use, that will eventually roll up to a PMO workspace. We plan on getting licenses for the PM if we go to production after the pilot. Each PM has multiple clients so they would …
Formulas and Functions24Fernando Flores
Can I send a PDF of a Dashboard on a reoccurring basis? Recipients just want to receive by email on a regular basis and not need to login to view.
Is there a way for a workspace to alert the individuals that have been shared to that workspace when a new sheet is created or added to the workspace?
Using Smartsheet28Renée Wager
One thing that frustrates me the most is not being able to remove shared users easily.
I know in the User Management section I can type in a e-mail address and have that person removed from all shares.
However, I have 100+ shares. Why isn'…
Is there a way to have a setting on a sheet that would allow it to override the restrictions put in place for automated alerts going to email addresses that are not in our Approved Domain Sharing List?
Here is our scenario. We locked dow…
I can see through Activity who has viewed the actual sheet, but can't find anything on how to see who has clicked into the published sheet link.
Using Smartsheet12Kim Clinton
Hey everyone! I am a Product Marketing Manager at Smartsheet who helped create the Coronavirus Preparedness Template Set available on Solution Center. It’s exciting to read the feedback you’ve submitted and scroll through LinkedIn to hear …
The New Work/Life Reality419Hunter Reed
I have a commission sheet set up to payout multiple agents and I only want the user to be able to access and see their payouts.
Is there any way to share a sheet where the logged in user (free user) can only see what was assigned t…
Hello! We are trying to find the best way to track employee training and certifications categorized by department and type of position. Has anyone been working on anything similar that they could share?
Using Smartsheet35Michael Maxson
I got Power BI Desktop to load graphics into a dashboard. Only problem is that I have to login too often. Is there a way to keep the graphs always open in the dashboard?
Premium Apps and Integrations21Joseph
Before I lose my mind, here... please tell me that there is (at the very least) a way for individual users to create filters without being shared to the underlying sheet. Up until this change, our users were able to access the …
Premium Apps and Integrations67Kyle Morgan
Hello - I have searched the community and have found a "work-around", but it doesn't work. I am trying to show a calendar view of a clients project on a client dashboard. I only want them to be able to see it. I don't want them…
Using Smartsheet617Jef Forward
I have added the email address for a specific Dynamic View I would like for them to access. Now what? How do I point them towards the Dynamic View so they can gain access and see it? Does Smartsheets send them an invite email…
Using Smartsheet94Stephanie Stoewe
I am looking to share only select results of a Form using a Report, but, in order to do so, it appears that I would need to provide access to the initial Form results. Is there a way to avoid doing that so that the person cannot see all of…
Using Smartsheet21Brad Wolff
As a Smartsheet user, I want to be able to refer to a row when typing a comment so I can better give context and easily give URL's to navigate quickly to the other row.
I leave a comment on Row 1. Row 1 is…
Using Smartsheet17Brett Wyrick
I need to share a workspace with some users with the exception of a few sheets that have confidential information. Is there a way to share everything except those sheets? There doesn't seem to be a way to do that without removing workspace…
Using Smartsheet17Neil Feldman
Please develop the ability to share Pivot and Datamesh configs. It is difficult for me to support my users when I cannot access their Pivot and Datamesh configs. Also, it makes it more convenient in training users when they can see what I …
Premium Apps and Integrations26Cody Stevenson
The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design req…
This might be unrelated to the Windows 10 update, but it happened at the same time. In Chrome, she can no longer see some of the drop downs on a sheet that has been shared to her for quite some time. We have tested other sheets and she can…
Using Smartsheet13Joanne Isenhart
Hi Smartsheet Community,
I do not have a paid subscription but was set up as an Admin for a sheet. I had only shared it with 2 people before it sent me a message that I had exceeded the number of email recipients that I could share with. I…
Hello, we have a dashboard that we want share among different groups but in our testing, we saw that the email notification notes the various emails that are included. Is there a way to hide these email aliases? Since these are different g…
Using Smartsheet35Ryan Nix
I shared a sheet with a non-licensed and gave them admin rights, but they are unable to make column property changes.
Is this the norm? I thought that as long as they were given admin rights they could make those changes.
Using Smartsheet109Shawn O'Banion