-
Issue with Health Symbols
Assume a single parent cell with two children. Here is the formula I am using: IF(CONTAINS("Red", CHILDREN()), "Red", IF(CONTAINS("Yellow", CHILDREN()), "Yellow", IF(COUNTIFS(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green", IF(COUNTIFS(CHILDREN(), "Blue") = COUNT(CHILDREN()), "Blue"))) The issue is the Green and Blue. If…
-
Does smartsheet support the functionality to show progress bars on a Dashboard? If so, how?
I'm looking to create a dashboard to visualize % completion of projects - most of which are multi-stage. To add a cherry on top, some tasks may be completed in different orders, although everything would have to be complete to complete a "stage". If I had to cheaply describe what I'm trying to do, please see image below.
-
Why do some names appear with a bubble in a Contact List column and other names do not
I have a sheet with a Contact List column type called Task Owner. I also have Summary fields set up that are Contact List types. The Task Owner fields are formulas to pull from one or more of the Summary fields. Example: Row 1 has a Task Name, Task Owner, Status, % Complete, Start Date, End Date, etc. The Task Owner field…
-
Smartsheet Calendar - Render event to actual start & end dates
I'm creating a project visual-timeline using the Calendar App, but the tasks are spanning entire time periods instead of representing the actual task timeline. Phase 1 completes on Sep 1st, but it shows running through the entire month of September. Phase 2 starts on May 15th, but it shows starting on May 1st. How do I…
-
Add Column to Row Report that was not in original sheet
Hi! I have created a Row Report containing information from just one sheet, with one "What?" criteria. I have the desire to add another column to this report, that does not come from the original sheet, just for notes purposes. This column would have sensitive information in it that I do not want the other owners of the…
-
Smartsheet University: eLearning Core App path & Badge for $199 vs Core App Path for $849
Two Questions: 1) What is the difference between these two options in Smartsheet University, aside from cost? The eLearning Core App path & Badge for $199: https://smartu.smartsheet.com/plan/elearning?_ga=2.69681488.1544627771.1692635313-18372609.1692651375 The Core App Path for $849 (does not appear to offer a Badge):…
-
Reminder workflow not working
I have a workflow specific to a rush order. When rush order is stared on the form, the workflow triggers to run hourly. Then there is a condition "If rush order is "checked" and status is "submitted" instead of accepted or declined it sends a reminder to the approver. The alert works once but doesnt continue to send…
-
Target Completion Date not rolling up and duration is way off
Hi, I can't for the life of me figure out why a subsection in my project plan is not rolling up the target completion dates and somehow it's going to take over 100,000 days to complete this section. I've unhidden all cells, double checked the dates, the Dependencies look fine... I'm at a loss. The other subsections are…
-
Help!: New dashboard errors for only some users on some charts
A dashboard that was functioning for all, but still under development suddenly began displaying "Unable to display chart" but only for some users and some charts. The charts that are erroring pull from the same sheets as charts that are displaying just fine. I have opened a support ticket with Smartsheets. Here is what I…
-
Blueprint Portfolio Summary Updates
I have about 400 projects in a blueprint right now. We created a new summary data point for all projects, but now we want to add the data point as a column to the portfolio summary sheet. In the past, I have either manually gone in and linked the 400 projects' new data points into the new column or went into the control…