-
Display RYG based on calc of two sheet summary fields and IF/OR statements
Hi, I'd like to display Red, Yellow, Green in a Sheet Summary field based on the calculation of two other fields, Past Due and Total Tasks. I'd like it to show Red if Past Due divided by Total Tasks is greater than 60%, Yellow if between 40% and 60%, and Green if less than 40% I'm new to Smartsheet so could be way off:…
-
How can I copy the value from a smartsheet summary?
I feel like I'm going crazy but I can't figure out how to copy a value in my clipboard from a smartsheet summary. There's no option in the dropdown and whenever I click into the field it tries to edit the equation. Am I the only one that wants to do that? Is there a very easy way to do that that I'm not aware of? I'm…
-
Generate a Report by using sheet summary
I'd like to generate a report that shows : Which tasks are in progress ( Including their parent ) which tasks are at risk ( Defined by tasks that were supposed to be started but are not started yet ) and it should show their parent as well. One of the problems I have is that under a given milestone, there can be several…
-
Sheet Summary Formula for Number of Tasks Complete (Not Started, On Hold and In Progress)
Looking to find a formula for number of tasks in each status- I have this so far but I'm getting the #UNPARSEABLE error. Please help =COUNTIFS([Status]:[Status], CONTAINS("Complete" @cell)", [%Complete]: [%Complete], 1)
-
Sheet Summary - Show completed tasks and status
Below is an example of one of my sheets in smart sheet I would like to add a sheet summary that : Shows the status of the overall project automatically ( in Green/Yello or Red) by calculation, as in looks to see if the status of the items that were supposed to be finished in the last two weeks are Done and if the status of…
-
Parents and Children relationships
I have the following items I need help with: 1) I would like my children rows to automatically display Parent | Task Name For example in this configuration: Parent 1 Child 1 Child 2 I want to see below instead of above Parent 1 Parent 1 | Child 1 Parent 1 | Child 2 So I need to apply a column formula that would do this.…
-
Filtering with a formula, but stuck
Hello, I'm trying to filter a summary sheet metric using the following formula but I keep getting "NOMATCH" or "UNPARSEABLE" depending on what I move around. The issue seems to be when I add the Country criteria. I want to filter to just United States and Canada: =SUMIFS([Total employees]:[Total employees],…
-
Summarize Report Function with Dropdown Menu Selections
Hello, I am looking to determine the instances of a particular dropdown value entered into my sheet by using the report function with the summarize feature in order to determine, based on the weighted value, how large a portion of total any one category may hold. Easily thought about as a pie chart. My dropdown values…
-
Sheet Summary Report with Dropdown
I'm creating a sheet summary report to use for a dashboard and have my source data broken out by phases. I'd like to be able to group the report data by phase, so I tried adding a single selection dropdown to the sheet summary. However, it's returning blank in the report. The source data is a project management / Gantt…
-
Smartsheet report cell linking not working
Hello, I am trying to edit a Smartsheet report to update a dashboard and cannot get the content to populate. I linked the correct cells into a summary sheet called Portfolio and the data is populating correctly. But when I go to pull in a specific column data from Portfolio to the report sheet called Report, the column…
