-
PowerBI Connector and Reports - Visuals Stop Working after Gateway-side Refresh of Data
Context: I worked on a dashboard that's pulling dozens of sheets and merging them together into a dataset. It's time-consuming to add each Sheet to PowerBI and requires many manual steps. I've explored using a Report as it can automatically pickup new sheets automatically, adds the sheet name, etc. When I import into…
-
Scheduled Report Email Not Sending – Next Send Date Reverts to Never
I am experiencing an issue with a scheduled report email that is not sending. I have exhausted all troubleshooting steps on my end and need some insight if someone has experienced it before. I have set up a scheduled email via File → Send as Attachment with a weekly recurrence. After saving the schedule, the 'Next sent…
-
Building a formula based on a check box
Good afternoon. I am trying to solve a problem with our projects (we do not have resource management). for projects that are escalated we have a check box that our managers then see with a report due to the check box. Once the project is back on track, the check box is unchecked and the project goes back to the PM. I want…
-
Tracking & Reporting on Project Hygiene
Hi All! I am starting to explore the possibility of tracking the "hygiene" of each project being managed by our team. We have a control center solution so the artifacts all of us on the team are consistent/templatized and capable of collecting data for a rolled-up portfolio view. So I'd like to be able to leverage that to…
-
AI for Reports
Will this feature be added to reports? Will CoPilot be integrated into the AI options?
-
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…
-
Send Dashboard via email - manually and automated workflow
My idea is to create functionality to be able to send a dashboard snapshot via email from within Smartsheet, both manually and via an automated workflow. Ideally using an HTML format so any links in the dashboard are links in the email. Smartsheet Dashboards are fantastic and we use them heavily with our project teams and…