-
Multi-Layer Gantt Chart
Hello, I'd like to create a Gantt chart which allows me to layer an original date range and an actual date range. This way, I would be able to show how a schedule has changed against an original base line. Ideally, i'd like to be able to see the original date as one color, and the actual date as a slightly different color,…
-
number of days between one state and another (not including weekends)
I need to include a column that shows me the number of days that a person maintains each state (not including weekends), if you don't enter the form every day to update the information. Could someone help me with this? date of creation| Name | Status | DAYS WITH THAT STATUS 03/03/2018 | cristian | busy | 1 02/27/2018 |…
-
Slow response from Smartsheet
Is this due to the number of open sheets (5 open tabs), size of sheet, computer processing power, or network speed (25.36 Mbps / 5.78 Mbps download)? Terry
-
Business Days
Someone knows how to include weekends in a single row on one sheet and that all other rows include only work days? Thanks!
-
Expand All after applying filter doesn't work
We have a sheet that has a primary column of parent categories with about 20 child tasks under each. The problem we are experiencing is when we filter by another column, the parent / primary column won't expand to show ALL of the child tasks. Below is an example of Program Name (primary column) expanded. I want to FILTER…
-
Creating Sub-Auto Numbers
Hello, We are currently using a web form for customers to submit a service request. After the form has been submitted a auto-numbering confirmation is generated and the customer is sent a notification with that confirmation number. When we process the request we often need to split the service request into multiple…
-
Labs- Smartsheet Charts
Hi, I have created a few charts on smartsheets labs, i am however getting this error on certain columns: All series on a given axis must be of the same data type These columns are the only ones to have negative values (-30 etc). So my first question is does the smartlabs charts allow negative values. My second question is…
-
modifying formulated cell in a report
In our main sheet, we have several simple Sum formulas for numbers and some for dates. We have several reports created that contain columns with the formulas. While in reports, you can change some data in each cell that will carry back to the main sheet and save. Other data is not allowed to change (even if the column is…
-
Ruler - alignment tool
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
-
Color Changes and Filter Bar?
Perhaps I'm loco, but 02/13/18 during the morning hours, I did not notice anything unusual about my landing screen colors. I log on after I get home, and my open tabs are now Orange and blend in too well with the background, and I now notice a Filter bar. Was this an update? I don't like it. Can we please get another…