-
countif from 8 different sheets with data criteria
Hello, I have a head scratcher here, I have 8 different sheets that I am trying to pull counts from and only from a certain day. Example: All sheets have a date of outreach, all sheets have a outcome. I want to pull the count of all outcomes marked "Mbr Reached" from 12/02/2025 from all 8 sheets. Question: Is there a…
-
Merged: Printing Reports
This discussion has been merged.
-
Provide users with the ability to Print a Grouped Report
Per the 1.5 years of queries being made, I believe there is suitable interest from the Community that Smartsheet provides the basic functionality of being able to print a Grouped Report. The system currently reverts the Report to a basic Sheet when Print is selected. This is not suitable or acceptable. We've stopped…
-
Published reports no longer include highlight changes, print, view icons
I have dozens of published reports that I've used for years. Below the title, there's always been the toolbar icons to print, highlight changes and toggle between calendar/Gantt/card view. In recent weeks, the toolbar has disappeared. I've tested creating reports from different sheets, and cannot make it appear. I need to…
-
Viewing Full Year in Calendar View
I would love to be able to view a full calendar year in calendar view. (We are a school district so I would want it to show July 1, 2025 to June 30, 2026). I create a Professional Learning Calendar every year and would to start using Smartsheet to do this instead of google sheets. I have transferred all of our PL events…
-
View a Full Calendar Year in Calendar View
I am new to using Calendar View. I have been searching around and messing with it today, hoping to move our district's PL calendar into Smartsheet (I currently build it in google sheets). Is there a way to view a full calendar year in calendar view? (We are a school district so I would want it to show July 1, 2025 to June…
-
Sum based on two columns, words and sum numbers
Hello, I am trying to figure out a formula that will SUMIFS my first range says "Perfect Match 111" and my second range has a number in it. Example if "Perfect Match 111" is in my first range 3 times then I want it to sum the number that is in my second range. So below I would want 6 to come back to my sheet. I have tried…
-
Request for Dashboard Chart Widget to Support Multiple Groups in Report
Currently, chart widgets on dashboards that are sourced by a report with multiple groupings only display data for the first grouping. This request is to optimize the chart widget to support data from multiple groupings in a report. For example, in a chart widget, display how many hours are planned for each team member,…
-
How to best track Outstanding Update Requests
We are a construction company and I am trying to build automations and a dashboard for tracking "Outstanding Update Requests" - Each of our Line-Item tasks require us to acquire information from 3rd parties. This information takes standard forms (Start Date, End Date, Comments, Attachments, etc), but the specific fields…