Best Of
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
Re: On Track/Off Track
Good morning, @Kasey Mabary. I think I was able to create what you are looking to do. Please let me know if this is not the direction you were looking to take your response.
In order to make this work you are going to need to introduce an OEC Status Helper Column and then one "Helper" column for each OEC Status grouping you have. So in your example above you shared "OEC - Kickoff" and "BLD - Build In Progress" as two phases. Each one of those will get a helper column to calculate the value of your checkboxes. This helper column, once programmed, can be hidden from view.
Below is the spreadsheet I made with your data. You will see that the formula automatically assigns "OEC - Kickoff" to the OEC Status column if the total number of checkboxes is 5 or less. This would be the equivalent of checking off every box under the Kickoff options. Then it automatically assigns a value of "BLD - Build In Progress" to the OEC Status if the check boxes total 6 thru 10. Which would be the boxes correlating to the next phase, plus having completed all of the kickoff phase previously. It then assigns a value of "No" when the check box total is LESS than 5 and status is "OEC - Kickoff", or when the total is less than 10 and the status is "BLD - Build In Progress." It assigns a value of "Yes" when the OEC Status is "OEC - Kickoff" and the total number of check boxes is 5, etc.
For the "On/Off Track" Column it is a Text/Number column with the following column formula:
=IF(AND([OEC Status]@row = "OEC - Kickoff", [Kickoff Helper Column]@row = 5), "Yes", IF(AND([OEC Status]@row = "BLD - Build In Progress", [Before Build Helper Column]@row = 5), "Yes", "No"))
For the OEC Status column you will need to replace your dropdown with this column formula in a Text/Number column:
=IF([OEC Status Helper Column]@row <= 5, "OEC - Kickoff", IF([OEC Status Helper Column]@row <= 10, "BLD - Build In Progress"))
For the OECE Status Helper Column (which you can hide) use the following column formula, which you will add more helper columns to for the other categories you have:
=[Kickoff Helper Column]@row + [Before Build Helper Column]@row
For the helper columns for Kickoff Helper and Before Build you will use these formulas, and again, need to add the same type of formula for any other categories you need a checkbox section for:
=COUNTIFS([Kickoff - SP Status Updated]@row:[Verify OE Wizard is Disabled]@row, 1)
=COUNTIFS([Before Build - SP OE Type Updated]@row:[Before Build - SP Docs Received Task]@row, 1)
I hope this helps! Please let me know if you this is not what you were looking for, or if it is and you need help expanding the formulas.
Regards,
Brian
Brian Wilson DC