Hello, I have 7 source sheets that I would like to use for a sheet summary report. Only one of the sheets is returning values to the report. All the sheets have the same 'Status' column, with the same…
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…
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…
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 whe…
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 "m…
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 t…
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…
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 …
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…
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 th…