Best Of

Automatic WBS Numbering

We have a work around but it takes multiple helper columns and complex formulas.

You need WBS numbering

1.1

1.1.1

Tracy Blumen

Re: Multiple If Statements

@vjschmid

Let's look at a simple example. Such as a sheet with video types and results for favorites:

Let's take the first Video Type of Movie and write a simple IF statement for it:

=IF([Video Type]@row="Movie", "Forest Gump")

We've only given the TRUE result for IF the Video Type is a Movie we want it to return Forest Gump. We haven't specified what to do if it's not a Movie. Next let's write a simple formula for Cartoon:

=IF([Video Type]@row="Cartoon", "Spongebob")

Again, only giving the TRUE result for if it's a Cartoon. Now let's write one for TV Show:

=IF([Video Type]@row="TV Show", "Game of Thrones")

Now that we know what we want to nest together, let's do that. To nest IF statements, you only give the TRUE result and then you start over with the next IF where the FALSE should be. Such as this:

=IF([Video Type]@row="Movie", "Forest Gump", IF([Video Type]@row="Cartoon", "Spongebob", IF([Video Type]@row="TV Show", "Game of Thrones")

Some people only give Nested IF statements TRUE values and assume that they're always going to find a match and have a TRUE result. However, to be safe some people add in a double quotes so that if all TRUE results aren't met with any matches it'll just leave the cell empty. To do that you'd add those double quotes at the end like so:

=IF([Video Type]@row="Movie", "Forest Gump", IF([Video Type]@row="Cartoon", "Spongebob", IF([Video Type]@row="TV Show", "Game of Thrones", "")

Additionally, you don't have to close the loop on all your statements with ))). SmartSheet will fill those in for you. So you could just type this into the cell and you'll notice SmartSheet will end with ))) for you.

=IF([Video Type]@row="Movie", "Forest Gump", IF([Video Type]@row="Cartoon", "Spongebob", IF([Video Type]@row="TV Show", "Game of Thrones", ""

Lastly, for the formula example you provided I don't think you're after an IF formula with an OR function. You're probably after something like this:

=IF([How many xyz]@row = "0-3 xyz", "$50-100K", IF([xyz?]@row = "4-10 xyz", "100-300K"

Then just let SmartSheet put in the )) at the end for you.

Mike TV

Provide users with the ability to Print a Grouped Report

Per the 1.5 years of queries being made, I believe there is suitable interest from the Community that Smartsheet provides the basic functionality of being able to print a Grouped Report. The system currently reverts the Report to a basic Sheet when Print is selected. This is not suitable or acceptable.

We've stopped developing our Smartsheet documents due to this restriction and now sit in a holding pattern waiting for an update. - See Printing Grouped Reports - Page 3 — Smartsheet Community.

Richard Heath

Re: Meet Deanna Vandermeer, our June member spotlight! 🎉

Yay @Deanna! I totally agree - the Community is one of my most valuable tools - I'm trying to encourage our user base to get out here more often.

MCorbin

Re: Show Percentage from Sheet as Pie Chart in Dashboard

Hi @Brandon29

You're correct that a Chart in a Dashboard cannot map a single value like this to show percents. You'll need to have the second half of the value (what is the remaining percent to make 100%) somewhere in your sheet as well.

What I would suggest doing is add a helper column in the source sheet, perhaps titled "Remaining Percent". Format this column to be a % type of column from the toolbar at the top. Then add a column formula that subtracts the current % Complete amount from 1. For example:

=1 - [% Complete]@row

If you have blank cells you want to ignore, you can add an IF statement in front:

=IF([% Complete]@row = "", "", 1 - [% Complete]@row)

Screen Shot 2022-06-27 at 10.46.30 AM.png

Then you can hide this column.

In your Chart, you'll want to select both cells (the original % Complete and the Remaining Percent) so you can display this as a Pie or Donut chart and change the colours, like so:

Screen Shot 2022-06-27 at 10.49.02 AM.png

Here's a webinar you may find useful: Visually Display Your Data with Dashboards

Cheers,

Genevieve

Genevieve P.

Collapse Workspaces when searching for source report for dashboard report widget

Today, when adding the reports widget to the dashboard upon clicking for the source report user is presented with the dialog with all the reports across the Workspaces and this list is expanded by default making it difficult to scroll and look up (yes there is search but when you have reports with same name across folders and workspaces it is not very helpful).

Alternatively, user can be presented with the reports in the current workspace to start with.

Sameer Karkhanis

Dynamic dropdowns

The Contact List, Dropdown (Single Select), and Dropdown (Multi Select), are useful tools to control data entry. The problem is they require a lot of maintenance.

Through Bridges, we have a sheet that is populated with information from our ADP. It contains all of our employees. Using a Contact List column and selecting the range of emails on the Employee sheet, as values would be very useful.

Moving to the dropdown column, it would be helpful if we could set some defined values, but if a new value is entered, have that value added into "values" for that dropdown column.