-
Sheet Summary with 2 conditions including date range
Hello, I'm attempting to write a summary sheet formula that sums a number based on two conditions: 1 for entries <1/1/2021 and another column with a drop down choice of categories for only one category. Any luck writing a formula for a sum of two conditions? Should I be using SUMIF? How do I format both the conditions in…
-
Count Distinct Collect only returns 1, even when there should be none
I have this formula for a Sheet Summary field: =COUNT(DISTINCT(COLLECT(Goal:Goal, [Primary SD]:[Primary SD], ="SET", [Fiscal Year]:[Fiscal Year], ="FY2022-2023"))) Attached is a screenshot of the sheet. It is filtered to show only rows with Primary SD=SET, and you can see that there are none for FY2022-2023. So the Sheet…
-
Add Sheet Summary Reports to Dynamic Reports in Control Center
Include the ability to add Sheet Summary Reports as Dynamic reports in Control Center. We keep data in the sheet summary in multiple toolkits, it would be very convenient if we were able to add a dynamic report of sheet summary fields to get a holistic view of our profile, and be able to update the sheet summary fields…
-
pull data from Resource Management directly into the linked sheet/sheet summary
Would like a way to connect the project summary data in RM (project budget, incurred hours, future scheduled hours, project budget (fees), incurred (fees), future scheduled (fees) (see screenshot) into the linked smarthsheet/ smartsheet's sheet summary field.
-
Dashboard Bar chart
I want to show how many request have come each week and show this value on a Dashboard with a bar chart ? I also need to show the oldest request that has a value of "New Request" maybe put this value on a Card of Text area on the Dashboard ? Any help would be appreciated...
-
How to use COUNTIFS where there are 3 conditions (columns to be referenced)
I'm trying to create a formula in a metric sheet that is referencing another sheet where data is held. I've been able to set up a COUNTIFS formula that references 2 columns so far, but my issue is that it doesn't seem to let me reference a third column using the "formula builder" as below: I'm trying to use COUNTIFS to…
-
Moving Sheet Summary Fields
Currently to rearrange the fields in the sheet summary you have to open the field properties and then move it up or down one at a time. If you have a good handful of fields and then realize that the three or four at the bottom should actually be at the top... That gets to be rather tedious. Would would be great is if we…
-
COUNTIF Issue on Sheet Summary
I am trying to see how many times Q1, Q2, Q3, and Q4 appear in my "Quarter" column on my sheet within my sheet summary. I am using the formula =COUNTIF([Quarter:Quarter], "Q1") to try to get just Q1 and it is not working. Any suggestions on why that is not working?
-
How to use Summary to show the total of one column only if a specific drop down is selected
Hello, I am wanting to create a summary for a sales sheet. I have several selectable items on my sales sheet and would like to summarise how many of those individual items have been sold. I have a drop down for several items and then record how many of that item is required in quantity. I don't want to record the total in…
-
Sheet Summary
I'm creating a RAID log then wanting to pull the metrics into a dashboard. I've created the log, then assumed I need to create a sheet summary on it. I have the formulas correct for the levels of priority, but I'm unsure of what I need to do with the status (Open or Closed). Ideally, I want to filter out the Closed items…