-
AVERAGEIFS or AVERAGE(COLLECT()) Help
Hi! I am struggling to get this formula to work correctly. The Smartsheet-AI generated formula is returning #UNPARSABLE and I am not too familiar with Average Collect. The goal: Average the column "Total Days Open" if the following criteria are met: column "Business Type" is NOT "retail" and column "Division" is "Northern"…
-
Balancing governance and flexibility as Smartsheet adoption scales
Over the past year, I’ve been building Smartsheet systems in a multi-partner environment supporting project management, reporting, and operational workflows. As adoption has grown internally and across partner organizations, one challenge I’ve been thinking more about is balancing governance and standardization with…
-
Personal Account for Fun (And Practice)
I am always trying to advance my skills and so, being the unapologetic Smartsheet buff that I am, I now pay for my own personal Smartsheet account to play around and practice my skills on personal projects. In my heart I would like to someday live somewhere else and to help me determine where…. I built a Smartsheet. Using…
-
RAID Log for Program
Hi All, I’m looking for some ideas and suggestions regarding RAID logs. I currently manage a portfolio of 18 projects and would like to align each individual RAID log with a program-level dashboard. Does anyone have a RAID log template they’d be willing to share? Additionally, I’d appreciate any guidance on how to…
-
Duplicating a Report Sheet in Smartsheet
Hello. I have a report, and I want to use the same settings / filters on the report page but for different projects, so I "saved as new" and renamed it at the top, BUT, how do I clear it out so there's no existing information entered that's on the original report? ( I hope that made sense ) - any help or suggestions are…
-
Report for due dates
Hello! Does anyone know if there's a way to create a report for specific projects that reflect tasks that would be due on the same date? For instance, if several projects have the same due date, it will show up as such on the report so the manager would see this and due dates would not be overlooked. Any assistance is…
-
Audit-centric tracking report
I am trying to figure out the best way to create a sheet for tracking all programming changes made for our development team. We have several different features that can be updated at different time, and i need to be able to track the latest version, who approved the release, and the release date. Ideally an audit report…
-
Start Date Formulas not appearing in reports
Hi community - ran into an issue I've never experienced before. Across all my clients, we use formulas to project dates (we've used durations/predecessors in the past, but it's not our preferred method). If we look specifically at the "TEST - SD - Internal Scope Alignment Call" line, you can see the "Start Date" formula,…
-
Tableau x Smartsheet Integration
Being able to feed dashboard charts from tableau data/import tableau data into grid sheets/reports.
-
Resource management: any workaround to NOT enable dependencies?
There are other posts regarding why dependencies needed for the Smartsheet/RM integration, but I'm wondering if anyone knows of a workaround? I was beginning to explore Resource Management, but straight away there's a blocker because we need dependencies disabled in the projects. We need the ability to edit the End Date…