-
Project Management Solution
Hello, I wanted to share a recent solution I was involved in, what was brought to me and what I did to help this group get the data that they need. I work in Healthcare and our org is switching to a new lab software that will require inventory assessment and identify needs for additional hardware. We have over 700…
-
Workaround for hiding column headers in a report widget
I am building a dashboard showing the capacity of a services team over the next six months, so other departments can see when we have room to take on new work. The headline is a traffic light strip. One small sheet, one row, six columns, one per month. Conditional formatting fills each cell red, amber or green based on…
-
Multi-Project Dashboard - Assigned Activity Chart
I am using sheets to manage multiple product development projects through a basic, waterfall style process. I don't want to call it a "portfolio" because it is not set up as a Smartsheet portfolio. I have a workspace for new projects, and each project is it's own sheet in that workspace. Each row is an activity assigned to…
-
Lock Column on Report Regardless of Sheet Lock Status
I would like to be able to lock a report column even if the column on the sheet is not locked. This would come in handy where you want to create a report where only a few columns remain unlocked to help guide the end user on what they should or should not be updating. It's possible they need the information but don't want…
-
Looking for Inspiration: Attendance reporting/matching
Hello Community, I am not sure where to start with this project: I have a class attendance sheet that I'd like to build further and I'm not sure where to go with it. Here are the parameters: I have several groups of participants (cast members for various entertainment productions). Each group has different numbers, as they…
-
Highlight Changes on Dashboard
Hello, I have created a Sheet with a form. I have taken the data from this Sheet into a Report, and then onto a Dashboard. I have turned on the "Highlight Changes" feature on both the Sheet and the Report. Anytime there is a new entry added to the Sheet through the form, it turns the data yellow. Unfortunately, this…
-
Blank count is coming in as 0
I am counting status and I need a count of blank status but it is showing up as count of 0
-
Reports - Pull a Rolling 12 Months Instead of YTD
I have reports that filter out by specific dates and other criteria. Ex: 1/1/26-12/31/26. I just had a request to try and pull the data from the rolling 12 months (8/28/25-8/27/26 or something) instead of year to date (like the example above). Is there an easy way to do this without having to manually update the dates in…
-
How many Sheets are too many?
I have built a workspace to approve and track event requests that come in to my department. We are a simulation center so it helps create metrics around how many events are booked each year, a breakdown of the event classification, as well as how many learners come through. I currently have three sheets- One for event…
-
Include external (guest/contributor) user accounts on the login history report
I verified this with client support and I didn't see this issue raised anywhere, so I will enter as a product enhancement. We should know when any user on the system, not just member accounts logged into the system. This should be an integral part of the report. I am hoping I am wrong because it already exists and someone…