-
Excited to connect with the Health & Life Science Smartsheet Community! 👋
My journey started in medical coding and compliance, where I had the privilege of working with medical schools and even contributing to Epic's coding software design. Today, I'm a Change Management Strategist and Smartsheet expert passionate about helping biopharmaceutical companies and smaller medical groups leverage…
-
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…
-
Select which columns to copy or move from one sheet to another
As part of the automation it is possible to copy or move a row from a source sheet to a destinatio0n sheet. At this point all columns are copied/moved, and if a column do not exist it will be created in the source sheet. The request for this improvement, is to allow the admin or owner of a sheet to select which columns…
-
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…
-
Folder-level permissions
I have a Workspace with folders for different teams. Is it possible to give access to certain folders and not the entire workspace? Currently I am giving everyone viewing access to the Workspace and the editing access to specific sheets. It would be nice to manage the access rights on folder level
-
Sharing Externally using Control Center
I'm new to using control center and I have an internal team that wants to use it to create client specific reports and dashboards in addition to our internal information. The problem is there is certain information on the sheets that I don't want the external client to have access to, so I can't share a report with them. I…
-
Formula Functionality: RYGB Status Change Based on Date
Hello! I have reviewed Smartsheet Discussions quite a bit, but this is my first post. I am trying to correct a formula I made to change RYGB statuses. Currently the status correctly changes based on the following: Blue if a Date Resolved is entered. Green if the # of calendar days is > or = to 15 days. Yellow if the # of…
-
What formula do I use to count a specific text when multiple text values are in a cell?
I have a column with a drop down where you can select multiple options for one cell. It is tracking who is affected so it can list multiple departments. I want to track by department so I am trying to figure out how to count only a specific word in a cell when there are multiple valves in the cell. The formula I am using…