-
Sheet Summary Report Isn't Populating Columns
Dear Smartsheet Community, Help! I have 4 identical budget sheets that I would like to report/summarize. I can only assume that the Sheet Summary Report is the perfect solution. After I create the report and subsequently select add my sheets, it then askes for me to select my columns, but then doesn't show them. It only…
-
How can I change the date format in a Sheet Summary?
All of the dates in my sheets are formatted to YYYY-MM-DD, as that's a format that works well across our international teams. However, in my Sheet Summary, when I have it pull the date (=cell), it formats it as MM/DD/YY. That formatting then feeds into my report, and I can't seem to change it there, either. How can I…
-
Sheet Summary Countifs on columns with formulas
I'm trying to build sheet summary metrics utilizing countifs against multiple columns but the column ranges themselves have vlookups in it. Unless I hard code the column values so that they are static, my formulas won't work and giving the [No Match] error for my criteria. Is there a workaround for this?
-
Allow sheet Summary Reports as a source for Dynamic Views
It would be helpful to be able to share summary field information from multiple projects using Dynamic View and a Summary Report. Summary Reports are an excellent way to share summary field data for multiple projects. Sharing this data using Dynamic View allows the owner/admin to show key fields in a grid, then make…
-
How to count cells when they have multiple values selected, and I'm only wanting a specific one?
Because we can't use wildcards on the program, I am at a loss to set up a report that summarizes my sheet. I'm trying to determine how many entries are the 'Status' outlined in each Primary Column row, where the 'Suggest Solution' is the text in each column header. The 'Status' can only be one value, but the 'Suggested…
-
Summary Field that Averages Field Entries that are Less than Zero
I have a calculated field for the time over or under a deadline date. I want to create a summary field that summarizes the number of days overdue for projects completed after their deadlines. Right now I'm trying =averageif([field name]:[field name],<0,[field name]:[field name]) I get an "Invalid Operation" error when I do…
-
How to Calculate Percent Complete in Sheet Summary
My sheet is used as a task checklist for projects. It currently has a 'Status' column for each Child task with 4 dropdowns (Not Started, In Process, Complete, N/A). I am trying to create a percentage in Sheet Summary that calculates the number of fields that are marked 'Complete' in the selected cells. Pulled this formula…
-
Increase summary field limit (>300)
Hi, I'm running into another Smartsheet limit. This time on the number of fields in a sheet summary. I have about 150 fields so far and I will need more than 300, most likely. But I get this warning: Can this maximum number be increased?
-
Sheet Summary Formula
Ok I have 3 sheet summary formulas that I am trying to make into 1 formula - is this possible? =COUNTIFS([ESG Core - 4 units to pass]:[ESG Core - 4 units to pass], >=4, [Start date]:[Start date], <TODAY(-180)) =COUNTIF([Start date]:[Start date], <TODAY(-180)) =SUM(ESG# / [ESG %]#) * 100 It works as 3 but would look tidier…
-
Is there a way to weight the average in a sheet summary report?
I have a report that pulls from the sheet summaries of multiple sheets. One of the fields divides two other fields to show the % of items completed. However, when grouping & adding summaries to each column, the % completed summary averages the values below it rather than showing the actual % of items completed. In the…
