Discussions - Smartsheet Community

Browse Member Tips

HOW TO: Duplicate / Copy a Group
Smartsheet Support Documentation does not have a way to duplicate, copy, or export a group in admin.smartsheet.com/manage/groups There is, however, a workaround that doesn't appear to be posted anywhere so I'm sharing it here: Open the group in the group list at admin.smartsheet.com/manage/groups Select "View Group" Select…
Formula to add Months to Date
This is the simplest formula I can find to add Months to Date. This considers sum of months exceeding 12, converting it to January and adding 1 to the year. Where: Term column is the number of months to add, Date is the starting date. =DATE( YEAR([Date]@row) + INT((MONTH([Date]@row) + [Term]@row - 1) / 12),…
Pre-Filled Forms Using URL Queries: Tips and Tricks
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…

See all

Recent Discussions

PM III Opportunity at Centene Corporation
Hello Smartsheet SME's — Centene is hiring for a PM role that will be expected to dedicate half their time to developing, managing, and integrating Smartsheet (using control center) with our PMO Portfolio level PowerBi dashboards. Please see below for a link to the external job posting and/or apply if you are…
Is it possible to input data into PowerBI that feeds into SmartSheets?
We have a PowerBI report which pulls from a SmartSheet sheet. My users want to be able to update the SmartSheet task from within Powerbi, such as being able to add a new comment in. Is this possible?
(500) Internal Server Error - Power BI
Hi All, I use Smartsheet as a data source often in Power BI. For the last two years I have never had an issue with Smartsheet's API, but today I have been getting a "Web.Contents failed to get contents from <insert smartsheet URL here> (500): Internal Service Error. Is this happening to anyone else? Or is this just a me…
How do you avoid Power BI Semantic Model Error when column headers are modified (add/remove/edit)
For anyone connecting Smartsheet with Power BI and using sheets as sematic model, and set a scheduled refresh, you might have encountered errors where when a column has been modified, whether add or removed or renamed, the refresh is halted until. My usual fix is to download the PBIX and update source (Navigation) to…
Data Entry Suggestions for Siloing Data for Radar Chart
Hey everyone, I’m exploring the best way to use Smartsheet for collecting score card data and formatting it for a Radar Chart. Ideally, I’d like to: Enter audit results in Smartsheet Modify or structure the data in another sheet Format the combined data for visualization The goal is to merge audit percentages from the…
PowerBI "Failed After Multiple Retry Attempts"
Hi, I haven't seen this exact error on the forum, point me in the direction if I missed it. I have a Power Bi page running off Smartsheets data, nothing has changed in the past week apart from using Power Automate to schedule the Power Bi refresh. I don't believe this would have any affect. Since yesterday every time I try…
Merged: Anyone having issues refreshing Smartsheet data in Power BI reports?
This discussion has been merged.
WorkApps and PowerBI?
Does WorkApps on SmartSheet integrate with PowerBI? I'm trying to take information from a sheet managed by another department that they shared with me that's on WorkApps, but when I go to "Get Data → SmartSheet (Legacy/Beta)" on PowerBI I see all the sheet I own or I'm shared to besides the ones within WorkApps. If not is…
Export PDF's Links from Latest Comments
Would it be possible to view the PDF's uploaded onto the Latest Comments Row? So far, when the data is exported into Power Bi, any PDF's attachement aren't viewable, as the URL for the attachments doesn't seem to be stored within the export. I would like to be able to view the SmartSheet attachments within Power BI, which…
Add Connectivity to Power Apps
In Power Apps, there looks to be a perisistent issue with connecting to SmartSheets and creating a form. This sadly means the Power Bi reports I have created cannot have Power App intergration, which would have allowed editing of SmartSheet data directly from Power Bi. Are their any planned workarounds for this?
Need To Be Able To Connect Power BI To Datatables
There is a need for Power BI to connect to Datatables in Smartsheet. Currently, Power BI only connects to Grids and Reports. In order for data from a Datatable to be accessed, a workaround must be used. One common workaround is a Datatable feeding into Grids, and then Power BI can access the individual Grids. This requires…
Power BI Dataset Connector - Taking data into Smartsheet
Context/Scenario: The current Power BI connector allows Smartsheet data to be surfaced in Power BI. To get Power BI data into Smartsheet, a user would need to export the data to Excel and then use Data Shuttle to bring it into Smartsheet. Idea: A new or updated Power BI connector, similar to the Salesforce connector, could…
Power BI Integration and Adding/Deleting columns
I have our exit interview metrics built in Power BI from a form/sheet in Smartsheet! LOVE it, working great until I added 2 columns that I do not want in Power BI, not sure how to do this. I have tried removing the columns in Power BI, then I just get errors on the refresh that the columns are not that, I have no clue what…
Connecting Smartsheet to Tableau (Mac User)
Hi everyone, I am currently trying to connect Smartsheets to Tableau to create live dashboards using sheets from Smartsheet that I can share across my organization. I have explored the WDC method to set up this connection but with WDC 2.0 being deprecated in 2025 and with WDC 3.0 not being supported on Tableau public, I am…
Smartsheet.gov and Power BI
I use Power BI with my commercial account of Smartsheet. Can it also work/connect to the Smartsheet.gov platform? I saw another post on this but it was almost 5 years old, so asking again. Thank you!

Welcome!

It looks like you're new here. Sign in to post and engage.