I have a column chart as seen below: The summary sheet i use as the data source is formatted as below: I used a summary sheet instead of a summary report as it gives me more options to manipulate the …
Hello all, First time posting here. I'm using forms to populate sheets with data on quality inspections processed. I'm looking for a way to create an ongoing, active report of units (which are identif…
I have two reports both bringing in information from the same sheet. One is grouped first by country, then by month. The other is grouped just by month. For each of these groupings, I have it summariz…
So i was trying to edit a sheet summary report that was built from someone prior to me and i was struggling to make the necessary changes so ive made a new summary report, however, i am running into t…
Whenever we edit summary fields in a particular sheet, the resultant report refuses to recognize the name change and just removes the data for that field. We then have to manually add the summary fiel…
Hi all, We have a main spreadsheet where we keep all of our projects including the budget for those projects. I would love an option where I can either share that spreadsheet, but mask certain columns…
When trying to run this it shows "#INCORRECT ARGUMENT SET" error, not sure where i went wrong. =IFERROR(INDEX({East - Service Status}, MATCH([Ticket No]@row, {East - Service Range 1}, 0)), IFERROR(IND…
I love Smartsheet's features. When I left my corporate job to strike out as a freelancer, using Smartsheet as one of my primary management tools felt like a no-brainer. Unfortunately there are some fe…
Hello! I am stuck - trying to leverage a sheet summary field to sum a total, where one of the columns has two conditions that I want to exclude from the Sum. I can get one of them to work: =SUMIFS([Am…