Best Of
Re: Shortcut for counting lots of items in multi-select column?
Hi @RAdamowicz,
You could do this by copying the values from the Multi-Select column properties and then referencing each selection in your formula.
To do this in the same sheet, take the following steps:
- Create a new column called ‘Selections’.
- Double click the multi-select column that you’re wanting to count values of (I’ll call it “Major”). Highlight all values in the values field and copy the selection.
- Click OK/Cancel to close the column properties, then click the first cell in the Selections column and paste the values - these will be listed as one value per row.
- In another column (your countif formula column), use the following formula:
- =COUNTIF(Major:Major, HAS(@cell, Selections@row))
The “Selections@row” section means that the formula will count the option listed in the row, so there’s no need to type out the name of each Major and adjust hundreds of formulas!
If you’d prefer to have your count in a separate sheet, take steps 1 and 2 above, then paste your values into a column named Selections on another sheet. In the formula column, you can then use the following formula, creating the {Major} reference as the entire ‘major’ multi-select column in the referenced sheet:
- =COUNTIF({Major}, HAS(@cell, Count@row))
Take a look at the following resources for more information:
Does that work for you?
Georgie
Georgie
Move all tasks to new column, not just Parent cards!
I primarily work in card view, running the project via Scrum methodology. When I move level 1 cards into the 'done' column, it doesnt move the level 2 subtasks into 'done' as well. This is an expected outcome for Smartsheets, but I'd argue that when working in card view, you would only move parent card into 'done' when all the subtasks are complete too. So in cases where you have a few subtasks to update which would complete the overall card, just moving the parent card into the done column should also update the level 2 subtasks into done too.
leob72
Re: Can I pull in information from one sheet to another when there are multiple matches?
Hello @tmd1993 ,
It sounds like your Primary sheet is functioning as intended.
Your Secondary sheet challenges sound two-fold:
1) Identify unique Event by Office Location.
2) Aggregate Budget vs Spend by Office Location.
Have you thought of using the Pivot App? Learning Track Pivot App
This is not the only option.
Primary
Pivot App Setup
Test New Entry Pivot App Update Response SLA
Re: Mouse-over / Alt-text to Dashboard Widgets
Idea: enable "mouse over" functionality on dashboards.
For example, an explanatory field (black box) could be activated by a "mouse over" over an info field (i) (green circle). Example see screenshot
Miranda_1
Re: Change color of milestones in Gantt
Great idea! We use the colors of the bars to indicate different modules, which is super helpful. If we could change the color of the milestone it would help to differentiate different types of milestones.
MikeChambers
Re: Change color of milestones in Gantt
Is there any reason why this cannot be done and what is the likelihood of this happening in 2025? I see it was asked for as long ago as 2022
BrianB999
Re: new project using the control center: the move / copy rows have to point to new sheets created
We absolutely need this ability in Control Center. Without this functionality, the ability to use Move or Copy row automations within any projects provisioned by control center is effectively eliminated. It isn't sustainable to go into each asset in the newly provisioned project and update the destination sheet for every Move/Copy automation. If you are reading this thread, please sign in and vote this up!
AJohnston_1711
Ability to lock a user into an assigned "user type" within the new user subscription model
As an organization with an enterprise account over 30,000+ employees system admins need to have the final say if a user should be considered a paid member OR a viewer (free). I understand that we can do this review during the true up period but with that many users its a maintenance nightmare when users who are NOT a system admin get to decided if a user becomes provisioned over and over again via sharing vs a system admin locking a users account into a user type.
Erin Kim
Filter option for all Incoming Dates (or Outgoing Dates)
It'll be super helpful for our Schedule Owners to have Filter for all Incoming (or Outgoing) dates when they have many incoming dates in their schedule. (Sometimes those are start dates… but some are in deadlines etc. )
I know if we add helper column to capture that we can do that, but it adds additional steps and more columns to update…. just want to capture Cell linked dates.
Chizu Hieida