-
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…
-
How to find how many sheets are using forms in my account?
Is there any way to find out how many sheets in my account are using forms? (Short of opening up each sheet and clicking on Manage Forms! We have way too many sheets for that!) We need a way to estimate how many surveys our organization has out there. Thanks for any help.
-
Summary Sheet & Filter based on Form Responses with Multi-Select Dropdown
Hi all! Hoping for some assistance with a summary formula pulling in criteria from a multi-select dropdown response form... I have a dashboard that has a form embedded in it to allow the user to enter their desired criteria (see below screenshot) and then the bottom of the dashboard pulls in the metrics using the form…
-
Merged: Tabs
This discussion has been merged.