-
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…
-
Conditional formatting for Reports
The ability to apply conditional formatting rules from within a report would be huge. Having to modify the Source sheet for a specific report doesn't seem to be very efficient.
-
Public sector - public records requests
Hello, we are a public sector organization, and any information entered into Smartsheet is subject to open records requests. Is there anyone else who has to search and provide data in Smartsheet to the public? If so, how do you provide that information? If it is a project plan, do you export to a PDF? Does that include the…
-
Allow reports to be scrollable on mobile devices
We publish a report to the tablets in all our buses that tell the drivers when there is an off-route pickup. Sometimes there are too many requests to fit on the first page of the report as it is displayed on the tablets and there is not a way to scroll down. This is not an issue on the desktop version. Can you make reports…
-
"Save as new" with more than 100 items
Is there any way around the 100 item limit when using" save-as-new". I built a large reporting and dashboard structure with hundreds of individual reports and aggregate dashboards. The reporting structure is for a state agency that contracts with many partners, so lots of reports and dashboards for each individual partner.…