-
Auto-populate Contact List cell with Shared Users
Is there a way to have a contact list cell, auto-populate with the users a sheet is shared to? Currently, we need to share a sheet and then when using the contact list column we have to add the users again.
-
Short Interval Schedule
I am having some troubles making something like this in Smartsheet. It shows manpower throughout a project. Any Ideas how to structure a Smartsheet that would make it easy for the eyes? Gantt chart could be nice but how would i show the change is strength based on time? Thank you.
-
Edit Column properties
Hi I have created a column of type: Checkbox. I want to know if it possible to restrict the checkboxes to certain rows. Or will each row have a checkbox by default ? As shown in the image attached, I don't want all the rows to have a checkbox. Thank you
-
Restricting Send Row
Is there a way to restrict where a row can be sent through the Send Row function? I see that the Enterprise plan has the exact domain whitelisting functionality that I'm looking for but that's not a feasible option for us. Has anyone come up with a solution to prevent an authorized user who needs full edit rights from…
-
Why No Release Updates?
If I am not mistaken, Smartsheet had scheduled downtime this past Saturday to implement some improvements. Why is there no information posted to inform us of what those changes are? As the "go to" Smartsheet resource at my company, I should be aware of new functionality--regardless of how big or small. It may be something…
-
Date Calculation
I have 3 columns. 1 column is the date that the time begins, the 2nd is a factor that is either 1.5, 3 or 5. It is always one of these three numbers. The 3rd column is for the end date that is auto-calculated by taking the date in column 1 and multiplying it be the factor selected in column 2. How do I do that? I am really…
-
Indent under a lock row
Hello to all, I have a sheet for tracking material order. At the bottom there is a completed section with many parent child relation, see attached file. T0 completed, T1 year, T2 month, T3 project, T4 list of material. The sheet automatically lock every thing that is in T3 and T4. Rows in T0, T1 and T2 stay…
-
Need help getting comment to change in one box as each line status goes to complete.
This is my formula and it works only up to the line 2. Starting with line 3, it will only work if the previous line(s) get reset to 0%. I need the [Comments]1 to update as each [%Complete] status =1 with the next row Task and Assigned To. =IF([% Complete]1 = 0, [Task Name]2 + ", " + [Assigned To]2, IF([% Complete]2 = 1,…
-
Bulk Edit Smartsheet Settings
Hi there, I'm hoping somebody can give some advice on a quick way to bulk edit the settings on lots of smartsheets at once, to avoid going in to lots of smartsheets over and over just to change the same setting. I need to enable some notification rules, and change the email restriction option, on 40+ smartsheets (and will…
-
Chart Widget Slice Labels
Currently the only options to label the slices on a graph are by the percentage or the value. Is there any way to label the slices with the value label? It would be nice to have an option to place the legend on the graph. Are there any plans to add this in coming enhancements? Thanks.