-
Graphing Only Total Row From Summary Report
I want to graph my summary row of my report; however, when I select the report it does not give me the option to modify what is selected to be included in the graph which is the entire report. This report is built of summary data from about 50 different sheets so doing this using a metric sheet is not really an option that…
-
It's Only Blocked Until I Kick It
I have a formula that leverages some sheet summary formulas and returns a true/false to support a report filter. When I change data in the sheet the sheet summary formulas sometimes return a #BLOCKED, but it is not consistent. When it does, if I go into the formula and edit it (without actually changing anything), then the…
-
Creating a master metric sheet
I have been hunting through the threads for a few days, and have not been able to find a clear resource explaining how to set up a metric sheet and then combine into a master metric sheet. I had created a "metric sheet" with my metrics as columns (approx 50 of them), it appears from what little I can find I should have…
-
@ row used to determine month and year but summary formula is now invalid
Hi All, I have successfully created an @row formula to automatically populate in a cell in my sheet which is super awesome. For this example I am showing the Month Reported but I also used a similar formula for Year Reported. But now that I have that completed, my summary formula that previously worked no longer does. How…
-
Sheet summary formulas automatically extending when new rows are added
Hi community, I have a lot of formulas in the sheet summary of my sheet. They all start like this "=COUNTIFS(Project1:Project149, NOT(@cell = "Epic Line"), [Row ID]1:[Row ID]149, ISNUMBER(@cell), ....." Now the sheet gets new rows added every day but my number 149 in the formula does not update automatically to capture the…
-
Report Grouping Summary Rows in Dashboard & Attachements
Is there any update on when reports might keep the grouping/summary rows when sent as an attachment or displaying on a dashboard? I remember hearing this was 'in the works' back in February.
-
Count how many "On Hold" projects for the Sheet Summary
I have a sheet set up with a (Multi Select) dropdown, and a complete check box, & would like to get a count of how many projects that are NOT complete & are On Hold. COLUMN: Info Still Needed - is a multi select dropdown COLUMN: Complete - is a check box I have tried several formulas with no luck.…
-
How to summarize and visualize sheet summary data of multiple sheets?
Hi! I've been using SmartSheet to track progress of different business units on a particular project. Each unit has its own sheet containing grid data that they fill out, as well as sheet summary data where I calculate different KPIs (e.g. number of records with specific status). For each unit, the sheet summary data is…
-
How do I count how many projects are "In Progress" or "Completed" ?
HI There, I feel this should be easy to figure out but i cant seem to! PLEASE HELP?! I have a column called "STATUS" , I have a drop down menu with the following under Status STAUS On Hold In Progress Cancelled Completed How do I show / count how many projects are "on Hold" or "Completed" or "Cancelled" Ideally this will…
-
Need help with creating report(s) with data from a Survey
Hello, I am still fairly new to Smartsheet and need some help turning around data from a survey I sent out. I have 600+ responses that I used the Request an Update function in Smartsheet to obtain, that I now need to summarize and I have no idea how to start the summary process. The survey is regarding Security Services at…
