-
Editable Sheet Summary Report
It would be a good addition to Smartsheet to be able to edit data in Sheet Summary reports, just like we can edit regular Row Reports. I don't understand why the 'two-way' data entry functionality between Sheets and Reports does not apply to Sheet Summary fields.
-
Metrics Pulling Help
Hi there! I have a submission sheet and a metrics sheet. I am attempting to create a formula on the metrics sheet pulling from the submission sheet. I have no trouble pulling counts, but averages are giving me some trouble.. I am able to pull the average based on 1 criteria, but no more than that. I am looking to average…
-
Row-wise Reports of Sheet Summary data
Hi It would look much more elegant if the sheet summary cells in Smartsheet reports could be displayed in a row-by-row format, rather than just the current column-only layout. I feel this vertical arrangement, as shown in the attached sample image, would create a cleaner and more appealing presentation.
-
Include Sheet Summary fields in Row Reports
I've seen several queries about this, and workarounds but can't find a suggestion so here's one! I have multiple sheets with the same name (in different workspaces). I want to use a Row Report but separate out / summarise the entries per sheet. The only field I can use is "sheet name" which is the same for all, but what I…
-
Formula in Sheet Summary returns different count result than filter
I am trying to count new entries in a list added during the previous week. If I filter data on "Create Date" between the dates for Sun-Sat last week (eg 8/3/2025 and 8/9/2025) I get result A (65). In my sheet summary I used this formula: =COUNTIF([Create Date]:[Create Date], IFERROR(WEEKNUMBER(@cell ), 0) =…
-
Can a form be combined with a sheet summary report?
I need to combine a sheet summary report of existing data with a form that can capture and record new, incoming data. I've done both separately, but need to know if this is possible in one sheet.
-
Countifs between 2 dates with status
Within Sheet Summary I can't get this formula to work, it keeps saying invalid value. Any help would be greatly appreciated. I am attempting to create a dashboard for items I have being completed on time or not using "0" or "1" through other formulas within the sheet. For example, looking for the number of CPAs completed…
-
Countifs for cells containing a letter
Hello, I have a formula to count how many hours of work I have assigned to me in a given week. It has the following inputs: "Owner" and "1st day of week" and it looks in a different sheet for all rows that meet that criteria and returns the estimated hours for the tasks. My formula is below and I want a solution for the…
-
Center and middle justify summary fields in a report
I have created a summary field in my Smartsheet that is a formula: Overdue Tasks =COUNTIFS(Status:Status, <>"Complete", Status:Status, <>"Canceled", Finish:Finish, <TODAY()) Works just great! Returns a number that I would expect. The challenge is that when I create a row summary report that references the field Overdue…
-
Using sheet summary fields in an alert
Hi All, I have built a workflow where once certain conditions are met we send an alert to a few stakeholders where we give row details and reference some details stored in the sheet summary. At the moment I have not found a way to directly reference this information without adding a helper column to the row and using a…