-
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…
-
Checking box via mail
Hello, is there an option to make the check box "checkable" via mail update form? I have a column "Task accepted" and I would like to enable people to check that they accepted task via mail when they receive an update. I see that the checkbox is sent as image so I am wondering if there is a such option ( See attached…
-
Move Project with Predecessors
I need help moving a project that has predecessors. This is being used for a production facility to track the status of our projects. However, I have run into a problem when needing to move a project in the order of production. The predecessors are not moving with the project change. -I need the "Design" process of the…
-
The copy of the other sheet
Hello. I have two sheet, some column's headline is the same.Are there a method? when I type one sheet and the sames content of the other sheet will appear automatically.thanks again.
