-
Service grinding to a halt
Further to my other post this morning, we've now found that the service is grinding to a halt. Our office, and our clients offices are barely able to save any data to a sheet or report and it's crippling our day. Is there anyone else suffering so heavily today?
-
Dashboard Widgets- 5-why, fishbone, user defined table
Adding a 5-why widget, a fishbone diagram widget, and a user define table widget to the dashboard would be really handy. Also, ability to attach document from local drive.
-
Risk Level Formula
Hello, I am trying to calculate risk level automatically (by displaying RYG balls) based on the following: Risk Level is Green If I get one of the following combinations: * Impact = Low AND Probability = Not Likely * Impact = Low AND Probability = Likely * Impact = Med AND Probability = Not Likely Risk Level is Yellow If I…
-
Refresh Lane with Contact List
I have a sheet based off of another sheet that was created from an old Excel file. The original had a column for Assigned To that used a lot of non-standard names. Now that it's in smartsheet, I've changed these names to pull from the contact list. But when I go to the card view and try to switch to the Assigned To column,…
-
Simple way for creating dashboard on issue log
So I am logging issues on a sheet and there is a column showing the respective status (i.e. Open, WIP, Closed, etc.) for each of them. I m in search of a simple way to create a dashboard to show the no. of issues under each status on the same sheet.
-
auto tick box checked dependent on all dots green
Hi I have several columns when once all green dots turns the row green, done with conditional formatting, however I have a column with a check box and want a formula that automatically ticks the checkbox once all dots in row are green, please can someone help?
-
Random ODBC Errors AND SSIS Errors Saying Sheets doesn't Exist
Hi There I use Smart Sheet 32 bit ODBC component to connect to SmartSheet and pull data to SQL server. Suddenly I see errors randomly. There has been a random error appearing each time the SSIS package is run (SSIS package uses ODBC provided by Smarsheet), it is not stable with one sheet missing error. Each time the…
-
Working with dependencies is a nightmare
Dear Smartsheet, I have a two change requests, because at the moment working with dependencies is really inefficient and time consuming: 1. Auto calculate lag when creating dependencies: when I create a dependency it automatically changes start or end dates. This is very annoying and time consuming because you always have…
-
Conditional formatting is deleted by viewers when their cursor moves over a row
I have set up a sheet with conditional formatting that seems to work perfectly for me. When I share it, for viewers or editors, the conditional formatting gets erased on every row they move their mouse over.
-
attaching the same document to more than one line
Hi, does anyone know if it's possible to attach the same document to more than one line? Right now, I go line by line, and have to dive deep into a directory to link the attachment. I'm hoping there's a faster way. Thanks much!!! Danielle