-
Status RYGG Automated Formula
Hello, I am trying to create a status column which updates automatically based on the following criteria: * Green (Task is Complete): “% Complete” column = 100% * Yellow (Task is In Progress): Today’s Date is less than “Planned End Date”, and “% Complete” is less than 100% * Red (Task has not Started on Schedule): Today’s…
-
Auto-populate a value based on dropdown
I am trying to have a column with dropdown choices auto-populate a value in the next column. If IP-A is chosen in the AssetType column, the TotalHours column should display 1. If IP-D is chosen the TotalHours should display 15. I was thinking conditional formatting would work but it only formats text/background. Is this…
-
Editing Alerts & Notifications - how do I get rules to fire on existing entries
Hi All, Basically I want to know how I can re-fire alerts and notifications that failed due to errors and have been subsequently edited. Example described below We are testing a new smartsheet using alerts and notifications and a multi step approval process based on thresholds. We submitted multiple Smartsheet forms today…
-
Update Request Forms that Include Parent Rows
I am relatively new to using Smartsheet and have just introduced this tool to the business. In order to gain good buyin I am using the update requests to show how easy it is to keep sheets up to date. The one thing that is a little disappointing about this great feature is that there doesn't seem to be a way of including…
-
Predicting a bad situation
I have projects with 3 milestones, call them A, B, C C is dependent on B which is dependent on A. C is a critical completion date. If either A or B is late, C is automatically late and that is very bad. If A or B is late by X number of days, C automatically is now going to be late by that same number of days. I'm looking…
-
Two dimensional cards
Hi. When looking at the card view, it'd be useful to be able to see multiple dimensionality. For example, being able to see which cards each user has in which status. (see attached) Is there a way to set up that sort of view? (I have person and status both available in separate pulldowns) Matt
-
Project Parent Hierarchy not shown in PowerBI
Hi there, I am trying to connect Smartsheet and PowerBI, so that I can visualize data in PowerBI from Smartsheet. I have the connector working, and can pull data from Smartsheet, but it pulls the basic data (row level) for all rows with no way of distinguishing a child row to a parent row. So where I have roll-up…
-
Workspace sorting/hierarchy
I have a bunch of workspaces (each with neat organization setup inside them), but I don't see a way to sort, group, or create a hierarchy to the workspaces. Since I use Smartsheet both with my own company and with my clients, it would be great to have a way to "group" the workspaces so I can have "internal" and "external"…
-
Inventory checklist
I have to create an inventory checklit based on an Excel document I will have 2 main sheets: Inventory & Picks Inventory will have a list of all the SKU/units that we have per product. Picks will need to offer me the option to select one item from the Inventory sheet and once I pick it, it has to tell me if we have enough…