-
Notifications and alerts - by demand (immediate)
Hi all, Was wondering if there is a way to send notifications (alerts & reminders) to the entire sheet (all rows at once) whenever a user needs and not by a pre-defined rule? For example, the sheet owner want to be able to send update requests or notifications in the middle of the week, not in a specific day that he/she…
-
VLOOKUP with multiple search values?
Hi all, I like to streamline the project time sheets for my employees. I have two sheets: 1) A Master Project sheet, and a 2) Timesheet: Sheet "Master projects" Project No. | Project Name | Role | Team Member Values: * 1|Lion|Project Lead|John Doe * 2|Tiger|Project Support|John Doe Sheet "Timesheet" Project No. | Project…
-
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…