-
Disable sharing with free collaborators
For sheets owned by licensed users, is there a way to disable sharing to free collaborators (i.e. only allow sharing with licensed or non-licensed users), either on a per-sheet basis or at the account level (i.e. for all sheets owned by licensed users). Also, I think it would be very helpful to add a "user type" column to…
-
Index Match Values Based on Certain Parent Rows
First, awesome community! I've been looking all over for a solution to my problem, but cannot find anything that would translate to my situation. Hopefully I make some sort of sense describing my issue. Brief: I work for a construction company that specializes in high rise construction. For my department, I'm tracking…
-
Locked out of my account
Locked out of my account. It seems they assigned an administrator to my account and they have locked me out.
-
Can a non-licensed user edit Dashboards?
If I build a Dashboard and add a non-licensed user as editor. Will that person be able to edit and make changes to the Dashboard?
-
Viewer role with the ability to add discussion comments
I have given a number of my colleagues access to a worksheet with the Viewer role. However, they are unable to add comments under Discussion. Is there a way to allow them to do that?
-
Filters for Smartsheet Documents
Hi all, I am looking to add filters for Smartsheet documents. I am relatively new with Smartsheet and have been tasked with creating some documents and reports. We are attempting to model one of our documents after the picture attached (the first one). Here is a synopsis of several goals we are working on: 1.) One of our…
-
Automated Update Request Form Changes
I have created an automated workflow, using the Request Update step. This automatically creates the form to send to the user to update. I would like to change the way the form appears and allow multiple line entries. When I go into Forms, that form is not there to update. How do I update the automatically generated form?…
-
formulas
When I am trying to add several variables using =sum( formula and scroll to locate other variables, my formula is cancelled and I receive an error code. As if I can only use variables/amounts on desktop screen and not above or below.
-
Dates Formula (IF?)
Dear, I need help I need a formula that activates a status dependent on a date. I mean, it automatically gets the corresponding color if a few days have passed after sending a quote. Example, if 3 days have elapsed since the date the quote was sent, the status should be automatically set to Yellow And if 5 days have passed…
-
% complete is not rolling up from child to parent.
I was sent a Smartsheet project and am not sure how it was constructed. The % complete column for the child tasks have the amounts entered. The parent task does not report the calculated rollup from the children. I attempted to fix it by creating a new % completed column and entering the values by hand. When I entered the…