Is there a way to roll up health of tasks underneath the parent to reflect an "average" health, if you will? I have a formula for my children to render health, however, I can't seem to roll up to the …
Hi there If I'm correct, Smartsheet only provide the "Time Duration (i.e. Days)" as the basis for Porgress Measurement in Project Plan. It's good in a way, but not that professional. For now, I have t…
Hello! I have created a report, and used group and summary to show the count of each value in status: I have then created a new dashboard and added a chart widget pointing at that report: The dashboar…
Hi! I've been using SmartSheet to track progress of different business units on a particular project. Each unit has its own sheet containing grid data that they fill out, as well as sheet summary data…
Hi guys, do you know how to set up the following report chart in my dashboard? I have seen this kind of report chart in one of the Smartsheet webinars. My requirements to this report chart would be : …
I have a report that I am using to feed into a Power BI file. There's a column in the report for a link to individual project sheets, but this column shows up at text only in Power BI (For example, a …
Hi, I have a formula which displays the correct value at the sheet level =IF([Date Answered]@row = "", "", (YEAR([Date Answered]@row))) example output = 2021 or if there isn't a date present the cell …
Hello, I would like some help in designing a Master Project List, and a Master Project Executive Summary Dashboard. We have a Roadmap that contains each functional area's main projects/initiatives. Is…
Hello, I am new to Smartsheets. I have tried searching in the forums, but couldn't get a resolution. Below is the scenario. In Folder - Project Type 1 Project 1 Project 2 Project 3 Using Summarise fun…
