-
Using Forms as a Checklist
Hi I have a list of 96 items which need to be checked off as a QA task. I have the 96 items in the Primary Column and I have 8 further columns, four checkboxes for "Compliant", "Non-compliant", "Unable to Check" and "Not Required", one plain text column for "Comments", one contact list for "Next Action For" a text column…
-
Schedule Form Deactivation?
I'm doing trivia through SmartSheet forms. Everyone who is participating has until Friday at 11am to submit their answer. I know I can physically go into the form and deactivate it. Is there a way to schedule the form to deactivate at a certain date/time?
-
Change Google Drive Account
I've been experimenting with Google Drive to share docs on a Sight. I now need to associate a different Google account vs the original I used to test things. I am unclear how to do that. Can someone share how to make that change? Thanks.
-
Copying Alerts/Reminders
I use smartsheet to manage my new client implementations. Each new client gets a new smartsheet. The implementations are tough to manage beacuse of all of the different pieces of information and tasks that are needed from different folks, both internal and external, for for each implementation. Smartsheet has been great…
-
Formula does not always recognize "" for blanks?
I have an odd one that hopefully someone can shed light on as i am going a bit crazy :) I finally figured out a formula i have been working on for few days ... strangest thing it seems to have been the quotes that i was using ??.... I used the quotes (directly to the left of the enter key with shift ) as a blank and i…
-
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…
