-
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…
-
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…
-
Sheet Summary - same sheet VLOOKUP with TODAY()
Hi, My Column Headers are: Date, Total Opened Cases, Total Closed Cases, Total Backlog. I am attempting, and failing, to use the following variations of a VLOOKUP formula. Can someone help?? =VLOOKUP(TODAY(), {Date}:{Total Backlog}, 4, false) = #UNPARSEABLE =VLOOKUP(TODAY(), {Date:Total Backlog}, 4, false) = #INVALID REF…
-
Assistance Needed with Updating Month-Wise Data and Dashboard in Project Management
Hello everyone! I've recently taken over a project that was previously managed by someone else. I've observed an issue in the project's dashboard where the month-wise data, used for generating graphs, is only available until May (please refer to the attached image). Upon inquiry, I learned that the sheet containing the…
