Best Of
Re: Calculate average of mid-range
Amazing, thank you, you just save me some brain cells.
Your formula worked perfectly!

Can you integrate DataMesh into Control Center blueprints?
Back in 2021 this wasn't possible. Has Smartsheet added the ability to create DataMesh configs that are automatically created when a blueprint is used to spin up a project with Control Center? This would be so nice.

Re: Month to Start automation
I found that this works:
=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (MONTH(DATE(2025, 3, 31)) * 3) - 2, 3)

Re: Collections vs Work Apps
Workapps sets Smartsheet apart from all the other tools. Workapps is a very powerful workflow and division of duty/role design.
People just go to their workapp, period. they dont need to save favorites, they dont need to hunt through workspaces, etc. Just go to the pages you are assigned in the workapp and go from there.
I do'nt understand Smartsheet funneling everyone back to the file manager/workspaces view. That makes no sense and is hard to navigate.
WORKAPPS are where its at Smartsheet. You should be setting yourself apart from other companies, not going back to what they are doing, channeling everyone into file structures, charging for access to those files.
You need two business models. One for your core base clients, and one for your advanced clients that use workapps and the advanced tools (data shuttle, bridge, etc…)
Trying to shove all of them into one solution will not work.
If Workapps goes away, we are done with SS. Our users login to workapps.smartsheet.com. They do not login to SS home page as they get lost.

Re: Collections vs Work Apps
Collections is just a poor mans version of workapps. You basically have to create a collection within a workspace and only after an asset in the workspace is clicked on, then collection link is shown. There is no home for collections. No way for a user to see all the processes they are involved in one space, like they do when they log into workapps.smartsheet.com
We took our top workflows and processes that have multiple roles and access to assets to Workapps and built them in Collections and asked the users to give their feedback on working in the Workapp versus Collections and nobody liked collections.
- It takes longer to build through Collections
- Users dont like going to their file manager workspace to "find" their collections, they liked logging into workapps.smartsheet.com and see all their process workapps at their fingertips. Collections need to be above Workspaces and not hidden inside each one.
- You cant see who is in each role, you just hope whoever you gave the collection link to is shred to your assets in that collections. There is no "list" like you can see in Workapps → Roles. Plus you can see all the other Collections in that workspace, even if you are not tied to any of the assets in that collections.
- In a workapp, you can have a report as a page and make a role editor on that report and they can edit the report AND NOT be editor on the underlying asset (those no provisional membership). not in collections, they HAVE to be Editor on the underlying report (thus drive up provisional memberships)
I could go on, but I really dont see how ANYONE thought collections would be a better option instead of a workapp. The new user model, the thought of eliminating their coolest feature in Workapps, all just seems like a ploy to drive users back to sharing the core assets and thus drive up provisional members to increase revenue.
And this doesnt even get into using Workapps for portfolio or projects which is awesome. Through Collections, its seems to be a step back.
Sorry, my two cents. Something just doesnt smell right.

Re: Help with Conditional Formatting for "Overall Health" Column
You have already solved new condition 1. If there are more than 0 reds then it will be red.
For condition 2, you need to move the grey logic to the start of the formula (the order is what allows it to override). If there is more than 0 gray, return gray (overriding all other colors).
If not, then it will look at red, if there is more than 0 red, then return rend.
If no reds, then it will look at yellow, and return yellow if there is atleast 1 yellow, and if none of those things are true, it will return green.
=IF(COUNTIF(Resources@row:Budget@row, "Gray") > 0, "Gray", IF(COUNTIF(Resources@row:Budget@row, "Red") > 0, "Red", IF(COUNTIF(Resources@row:Budget@row, "Yellow") > 0, "Yellow", "Green")))

Display Welcome message with current user's name on a Dashboard
Hi,
I have a dashboard with many "Current User" reports. I would like a message on top of the dashboard to appear that says "Welcome" and then the current user's name.
What's the best way to go about doing this? I don't want to pull a report that has the current user's name on it because then you see the column header and grey column and row lines... I'm assuming I need a metric widget, I'm just not sure where to pull the name from, how will it change based on whoever is currently viewing the dashboard?
Thanks!

Re: If the value is negative, make it 0
You would use a MAX function like so:
=MAX(0, original_formula)

Sort pieces of pie chart
I want to be able to sort my pie chart pieces. For example I want to show the pieces from largest to smallest in order, such that I can more easily identify which the relevant pieces are by going from the biggest to the smaller ones and ignoring the bulk of "small rest" pieces.

Allow boolean operations across fields in Automations
When creating Automations I would like to set actions by comparing values across columns. As an example - if Actual Start Date is greater than Target Start Date then perform a certain action.