-
Correcting chart spacing
I am creating a chart on a dash board using a sheet summary report pulling data from 2 sheets. I am having difficulty arranging the columns as desired no matter how I adjust the widget tools or the columns in the report Specifically, One column that is pulling data from sheet "A" is on the left and the other 3 columns…
-
Sheet summary formula to SUM a column where cells are formulas
In my sheet summary, I am trying to sum/total a column where the cell values are populated as a result of a formula. I can't seem to get a value. The formula for the cells I am trying to sum is this: =IF([Item Type]15 = "Stand Alone", "150", IF([Item Type]15 = "Unfolding", "450")) It is referring to one other column. I…
-
SUMIFS - #Invalid Operation - Why?
Hello community, there is a formula problem which troubles me slightly. These formulas work perfectly fine =COUNTIFS({6M_category}, HAS(@cell, [Primary Column]@row), {Time of occurence}, >=[Start Date]#, {Time of occurence}, <[End date]#) & =SUMIF({Impact_to_production_hrs}, >0) BUT this one, does not and returns "#invalid…
-
How have folks summarized statistics from multiple sheets to feed a chart widget?
Our marketing folks use a new sheet for every campaign. During the span of a few months, there could be several dozen such sheets active. They are all built from a template and reside in the same folder . Within each sheet there are several summary fields that can indicate number of tasks, number of unstarted tasks, number…
-
How to add card and calendar view on Dashboard
Hi there, I want to add a few sheets in card and calendar view on a dashboard. Is this possible? I only see that reports can be added on dashboards, how do we also add sheets. Thank you, Esperanza
-
Sheet Summary CountIfs with Multi-contact fields
Hi, Is it possible to use a countIfs in a Sheet Summary referencing multi-contact fields? I would like to count the number of instance "Employee X" is in the responsible field column. However, i can't seem to get it to work. I tried using both Has and Contains function in conjuction with countIfs and no luck! Has Formula…
-
Options for Sheet Totals to Drive Dashboard Chart
Greetings, Community! Looking for some guidance relating to sheet totals and how to plot them on a chart. The below screenshot if from a pivot sheet. I mocked up a set of totals rows at the bottom of the sheet. My goal is to SUMIF based on the Category (SM, PF, PL, SysOps) for each time range. I'm looking for a solution…
-
Filtering by a Summary sheet field in a Row Report
I am trying to create a report that will include not completed tasks from all my projects with a due date either 5 days in the past or 5 days in the future. This way I can look at it and either get updates or make sure the resources are working on the tasks due soon. However, I have cancelled projects in my workspace that…
-
Creating a report by task owner and RAG status
Hello Smart Sheet-ers, I am fairly new to SmartSheet so excuse me if this is breathtakingly simple. I need to create a report of the following in dashboard. I assume from using Sheet Summary. It needs to show Task Owner, then how many tasks that are RAG status red, yellow, green, blue. I'm using the below columns: So for…
-
Can I use the data linked from another sheet, to populate my Sheet Summary?
Hello, I have this sheet I'm using to track projects status and health. Almost all data are coming from my team's project plans, and I use therefore the "Link from cell in another sheet" option (this way everything is automatic and I don't need to have manual updates). In the Summary sheet, I have setup a field in which I…
