-
COUNTIF is Not Working as a Sheet Summary Field
I am trying to create a count of how many rows in my sheet meet a certain criteria. I created a Sheet summary field and used the COUNTIF Formula. However, it keeps returning #NO MATCH when there clearly are rows that meet the criteria. SHEET SUMMARY FIELD FORMULA: =COUNTIF(Fund:Fund, 160) Here is a sample of the data in my…
-
Summary Sheet Not Connecting to Correct Column
I have a summary sheet set up for my projects, which is connected to a metadata sheet I have. In the metadata sheet, I have column types for different types of data (contact, text/number, date, etc). In my summary sheet, the columns that should be looking at the text/number column for data are looking at the contact column…
-
Update sheet summary field via a report
I am using row reports and sheet summary reports. When I create a row report , I can edit fields in the report and it updates back into the plan /sheet itself. This makes it easy for me to meet with a team member and review only their tasks across my plans and update % complete etc. Similarly, I'd like to be able to pull…
-
Add Grouping to Report Exports
When exporting a Report to PDF or Excel from Smartsheet, grouping and summary rows should be included. As I utilize a lot of automated reporting, via PDF, this would create consistency in the report view and exported view.
-
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.
-
Change summary email
There's an email that contacts on a sheet receive towards the end of the day when changes are made to a sheet. They'll receive the automated emails set up on the sheet as well as this summary of changes email. Is there a way to modify this email?
-
Sheet Summary with combined date fields
I'm trying to build a Summary field that pulls in the StartDate and EndDate. I'm using this formula: =[Start Date]# + " - " + [End Date]#. Does bring in the data from the two fields, but it includes the time as well as the date: "12/09/24 8:00 AM - 12/13/24 4:59 PM" Question: can I get this data with just the dates:…
-
Needing to update Summary Sheet mapping
Hello, I am thinking this is an easy question with an easy solution. I have a Control Center blueprint where I have mapped a column incorrectly, Text instead of Contact. The data is coming from the metadata file, which is linked in from the project. Is there an easy way to change the cell linking on the Summary sheet? I…
-
Display values from a row when a value in that row is a specific value
I am trying to create a reporting dashboard that displays elements of a row when a value in that row is "Yes". For example, if a workstream is blocked, the reference cell is "Is Blocked?" and if the value is "yes", I would like to display on the report the details of the workstream, the owner, and the reason it is blocked.…
-
COUNTIFS formula error
I am trying to calculate training sessions based on 2 columns : status column and year column. I've done this numerous times before however for some reason no matter what status filter I choose the outcome is 0 when there are definitely values for 2024 completed training sessions. This is the formula I am using =…