-
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.
-
Auto Populate Form Fields
I have a form that managers will fill out stating who participated in a project and what percent of the project they completed. I have a column that auto calculates the total percent (with conditional formatting) to help with the final review of the information. I would like the total percent field to show on the form and…
-
Revert to Single-User Contact Column from Multi-User Contact
Hello, Experimenting with the new Multi-User Contact Column, I've found out the hard way that it is treated as a separated Column Type. In other words, when running a report I need to have check 2 "Assigned To" columns. I went back to the Sheet that had the "Allow multiple contacts per cell" checkbox checked... and looks…
-
Linking Date
Hi I have a Master Smart Sheet and a number of other smartsheets linked to the Master sheet. I have trouble linking the end dates to this Master Sheet but no trouble with the start dates. I need to link the end date as that's the one that can keep varying and it is a lot of work to updating the new end date on the master…
