-
Keep child rows collapsed to the parent row at 100% completion
I like to collapse my rows to just see the parent row when the child tasks all reach 100% (I don't want the rows to to be removed from the report - I know it's an option not to display them when they reach 100%. It seems that, when I collapse them manually, some or all of them are open the next time I open the sheet. I…
-
Formulas
Hello, I need to multiply and the divide two columns but one of them already is a formula. It's a simple sum of children which for this example is 3 and in column 1. The next number is manually entered into column 2 which is 48776. If I enter a new formula in column 3 =column2/column1 and hit enter I get invalid operation.…
-
Blue checkboxes
Hello Smartsheet! What is the reason of colouring checkboxes bright blue? Don't you have any other more important jobs to do? Are colours the most important for your users? If you like to be so cool, then please let us choose alittle bit what is important for us and what is not. For sure this blue checkbox is not on our…
-
Add children rows automatically with same format
I have a parent row where its high level description of task, The clhildrens rows are action items and next steps that have unique formatting. I would like collaborators with minimal SS experience to easily be able to add children row with same formatting. Right no, the only solution is to copy/past which isn't ideal.…
-
Supplier Management - Template
Hi, I cannot find a pre existing template in smartsheet templates Do any smartsheet users have an existing template on their smartsheet account for Supplier/Vendor Performance or Evaluation, preferably with pre defined criteria, and pre formatted score chart and graphs? If so, are you happy to share this template? Thanks
-
Summarizing and aggregating for the same code from multiple sheets
Dear Expert, I have 40 sheets containing following column with example (example for one sheet only): Equipment ID | Equipment Group | Part Name | Quantity | Unit Price | Total Price 11MBX21 | AAF | Bearing | 2 | 150 | 300 11MBX22 | AAF | O-ring | 1 | 50 | 50 11MAK10 | BAC | Sensor | 2 | 500 | 1000 11MAD15 | BBA | Switch |…
-
Attachment line numbers
When I send attachments from a sheet that has many attachments it is sometimes hard to find which line that particular item came from, which would be very helpful. Is it possible to add the source line number in the automated email? And if the item is attached at the sheet level just have it say that? I'm sure I'm missing…
-
How to print selected columns
I'm new to Smartsheet and I have inherited some sheets from my predecessor. I'd like to print a Gantt chart and a grid. My question is, how do I specify which columns will be printed? When I print the grid it prints all columns I can see on the screen but I want to exclude some. When I print the Gantt chart it only prints…
-
Multiple Select
Hi I would like to be able to create a column drop down with our 8 of our staff names and be able to select multiple drivers in one column is this possible how do I do this? For example David, Richard, Pablo, Sarah And be able to select David & Pablo & Sarah in one coloumn Thanks
-
Auto remove or change content.
Hi, When i'm input the date @ "Done_DP", "Down Payment" became green, how to setup a formula to auto remove "Due Date 1"'s content or change to DONE (Due Date 1 are drop down list with "DONE") Thanks in advance.
