-
Sheet summary can be added to a report
I have created a report from 3 different smartsheets to merge it in a single sheet report. This report shows in a single view all our Purchase Orders from 3 different line of business Now I'm creating a dashboard to show quarterly trends (i.e. # requisitions submitted, # of requisitions completed and total requisitions…
-
Count, Children, Status
Hello, I wanted to create a report/dashboard that showed the total number of items under a parent and how many of those items were in a non-green status. I am entering my formulas on the Sheet Summary section. I have created the formula for count of children but am having a hard time showing count of those children with…
-
Sheet Summary Formula Error
I am trying to create summary field on a sheet to show how many rows contain a users name. The summary formula is as follows: =COUNTIF(VP:VP, FIND("a user name", LOWER(@cell)) > 0) This works fine when the column VP contains actual values with text. However, if I put in a column formula to calculate their name from a…
-
How to sum up a number of values with widgets
So I'm looking to create a widget that quickly shows me the number of times a value is represented. What I want to do is separate out a number of teams I have and see how many times each team has a "missing" value in it. I have rows broken down by team members. There's multiple columns, but their team name is one of them,…
-
Chart widget functioning wierd...
I have a report showing calculated numbers in 3 columns. The numbers come from the summary sheets on various project files. Other than the sheet name these are the only columns in the report. Trying to use the pie and donut charts it says they are not available for this data set. Trying to select the columns it only shows…
-
Summary Report not displaying additional columns
I'm trying to create Summary Reports but only ever receive the created date/name, modified date/name and sheet name columns to select from to add to the report. I've tried saving and going back in but no luck. The sheets I'm selecting all have the same column names as they were duplicated with the save as new function.…
-
Summing a summary sheet report
Hi all, I have built a sheet summary report, and this is showing the data that I would expect. I would like to be able to sum each column - (i.e. one of the columns is no of reports that are live) so that I can get a total, and to put this on a Dashboard either as a Metric or have 5 or 6 columns combined in a chart. Sorry…
-
Is there a way to copy Summary Fields to other sheets but not overwrite data already entered
HI, I have an issue where we have most Summary Fields that contain formulas but we have a few which are keyed in for integration with our CRM. I have created a sheet with the manual summary fields and another for formula fields but when I copy only the last set of Summary fields are stored. Additionally, when we add more…
-
Is there a way to use a CountIF formula that would ignore hidden rows/cells?
Hello, I am am trying to create a summary report that would count the number of "complete", "not started", and "In Progress" with only using the rows/cells that are filtered. I do not need to count the rows/cells that are hidden but when I use the COUNTIF function, it would also count the hidden rows/cells. Thank you.
-
Sheet Summary Formula Needed: Sum all numbers in a column for rows which match a criteria
Hi, I am looking for help writing a sheet summary formula that will sum all numbers in Column B for all rows matching a criteria in Column A. I have a sheet that tracks transactions by salesperson. Each row is a transaction. I have column that contains the commission for the salesperson for each transaction. In the sheet…
