Best Of
Re: Upcoming Tableau WDC 3.0: Timeline for Smartsheet Connector Update?
While we haven't yet switched to WDC 3.0, we're actively monitoring the situation. WDC 2.0 is deprecated, but not yet retired, and we're closely following any announcements from Tableau.
Our current implementation using WDC 2.0 continues to function as expected.
Chris Auty
Re: Parenthesis hell
Just a quick view shows you have 2 '@Row' on the final 'OR' next to [FN: Pruning]
VBAGuru
Re: Community Corner Newsletter [March 2025]
SAY HEY!!!! I LOVE YOU!!!
The world needs more love !!!! Everyone deserves to be loved and celebrated! Thank you for the reminder and sharing this song~!
Paul.Woodward
Re: Combination Charts
Hi @EBazan
Unfortunately, Smartsheet does not currently support the combo chart.
One way to create a comb chart in Smartsheet involves syncing your data to Google Sheets, leveraging its charting capabilities, and then embedding the finished chart back into a Smartsheet dashboard. Here's a guide on how to do this:
1. Smartsheet API Setup
- Get API Access: Generate an API token in Smartsheet for authentication.
- Identify Data: Select the data or sheets in Smartsheet you want to sync.
2. Google Apps Script Setup
- Create a Script: Go to Extensions > Apps Script to open the script editor in Google Sheets.
- Write Script to Fetch Data: Develop a script that uses the Smartsheet API to fetch the data you need and load it into Google Sheets.
3. Create and Customize a Comb Chart in Google Sheets
- Select Data: Highlight the data you want to create the chart.
- Insert Chart: Go to Insert > Chart, select ''combo chart,'' and customize the settings to fit your data presentation.
4. Publish and Embed the Chart in a Smartsheet Dashboard
- Publish the Chart: From Google Sheets, click on the chart, select "publish chart," choose the embed option, and copy the HTML code provided.
- Embed in Smartsheet: Add a 'Web Content' widget to your Smartsheet dashboard and paste the HTML embed code.
This approach utilizes Google Sheets's graphic strengths for better visualization and effectively integrates these visuals within your Smartsheet environment.
In the demo dashboard below, you can change the language of the Dropdown list and click the Google Apps Script link to trigger the update of the Google sheet's dropdown list data.
(Link to the demo dashboard)
Re: Happy 10th Anniversary Community + Giveaway!
How would I describe Smartsheet to a newbie… Hmmm..
Smartsheet allows you to work on the actual project and not on the care and feeding of the project documentation.
Leigh Roche
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet is like Excel on steroids—it’s got the grids and formulas you love, but turbocharged with automation, collaboration tools, and project management.
AnemonePoppy
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet is the tool to make you look good at work! 😋
Bruce Case
Re: Formula Issue
@kmercer Absolutely. No problem at all. Just remember the way the If statements work is it will search for the first true statement then continue on.
Mark.poole
Re: Some parts of the automation not running based on Index(Match) cell change
@kowal oooooo, so it's not a bug, it's a premium feature prompt… This makes so much sense. I do have Data Mesh but I was hoping to avoid premium features for this build since I am trying to create a template for unit managers with regular licenses. Thank you so much for your help.
vakhanka