-
SUM Rows in Column A that meet multiple criteria including distinct values in Column B
I am trying to use a formula to: Referencing other sheet(s)… Sum story points by PE (Person) if: The Parent PCR (Identifier) is Unique The PCR Status is one of 5 options The PE assigned is an exact match (ie "Derrick Franklin") Here are a few that I feel are close, but not giving me the exact number's I'm looking for: This…
-
Embedding from the Calendar App
Is there a way to embed a calendar you created from the calendar app without placing it as a widget in a dashboard?
-
Dashboards + iPads
More and more executives are working off of iPads (only). Unfortunately, viewing dashboards from an iPad is a very different (materially worse) experience than what one sees when viewing from a laptop. As a result, I am reticent to share dashboards with BOD members and major investors because the charts and graphs look as…
-
If they can't share = they can't delete rows and comments!
Having better user control over what users can or can't delete in rows and comments is crucial. I suggest that the current user levels be updated as below "Editor Can't Share" should be "Editor Can't Share or Delete" (If they can't share, they also shouldn't have access to Delete rows or Comments). "Editor Can Share"…
-
How can I make sure that I always share contacts with full names?
Hello everyone, I have an issue with the shared list displaying full names and not just email addresses. I am an admin on all sheets and if I try to update an email address and replace it with one in my Contacts list with their full name, it still doesn't show the full name in the shared list. For example: And this is my…
-
Share Dynamic View externally, without a Smartsheet account
It would be helpful to share a Dynamic View (via a sharable link) with parties external to our organization who do not have/need a Smartsheet account.
-
Dynamic View not allowing access
I have tried the following: Adding the “abc.com” domain name Directly adding the user to the shared email list Adding the user to the share if their name is in a field feature. Are there any directions on how to properly set this up for use? Am I doing something wrong or is there something odd going on with the system at…
-
Sharing a sheet- view access internally only
Im seeing in different places online that its still not possible to share a sheet with the broader org as view only? Similar to what GSuite and Box would allow. Wanting to embed links to smartsheet in an update but only find that there is one option that allows public access. Im guessing this is basic now but just not…
-
HELP! Why are access requests going to all sheet Admins?
Is there a way to turn this 'feature' off? Just because a person has been deemed an 'admin' on a sheet, does not mean they are aware of the sharing protocol and restrictions that the Owner may have. Instead of a blanket protocol, can the designation be set at the Workspace level or something?
-
Is it possible to share a Smartsheet that has a locked default filter with someone else?
We want to share a Smartsheet with others, but we only want them to see certain parts. To do this, we created a filter and set it to be the default view for people with viewer access. However, when we tested this with a team member who had viewer access, they were able to exit the filter. We want to prevent the person who…
