Best Of
Re: NEW! Custom dashboard themes
This is yet again a feature that has been very needed! I have already begun using it! THANK YOU SMARTSHEET.
Paul.Woodward
Re: Table view initial release is now generally available for all customers!
Love that quick search feature at the top!
Dakota Haeffner
Re: Table view initial release is now generally available for all customers!
What! Sort and Filter at the same time! Well I'll be!
nbers
Re: Table view initial release is now generally available for all customers!
It's going to be a big year… lots of "finally" moments!
Matt Lynn ACT
Re: How to show a blank instead of 0 using countsif?
I'm guessing your goal here is to shut down the visual noise created in a sheet if there's zeroes everywhere. So you have two options:
=IF(COUNTIFS ({MY25 CTM Detail Report Range 1}, "(7)Other Matter Requiring Plan Review")=0,"",COUNTIFS ({MY25 CTM Detail Report Range 1}, "(7)Other Matter Requiring Plan Review"))
Basically, create the formula so COUNTIF is mentioned twice: once to evaluate if it's 0, and a second time to tell Smartsheet what to do if it's NOT 0. Your formula is looking at the entire range of what appears to include text, so it's not going to be 0.
Option 2 would keep the value in the cell - possibly helpful if you need to create dashboard visualizations, or if you ever want to do math on this column. (The "" is basically saying "THIS CELL IS TEXT" so you could be forcing an #UNPARSEABLE error.) Don't make it blank, but rather use conditional formatting - if the countif column = 0, color the font in that cell white on white (or to match whatever your default background is).
Whichever direction you decide to go, good luck!
Kerry St. Thomas
Re: Customize Widget Colors w/o Being Locked into the Theme
Barak,
You've interpreted my feedback correctly. I would like optionality to individually change widget colors.
Thank you,
ColinG001
Re: Bridge Add columns based on values within multi-picklist
I've thought of a way to bypass this error, and allow you to have one Parent workflow with all the Child Workflow Modules below it.
In each of your Child Workflows, add the "Get Sheet" and "Array Management: Extract Field from Array" modules to get all the Column Names in the sheet before looping through to add the new column if there's a multi-select match.
This way you can add in a CONTAINS Junction to see if the array of column names in this sheet contains the name of the new column already:
If there's a column already in the sheet with that person's name, the child workflow will have a successful result (result of nothing) which will prevent it from ending in an error.
I've added in two fail states just so they appear in my run log and I can keep track of how the workflow is going through each module.
Here are the pieces broken down:
Get Sheet
Copy the Data Reference to the Columns array.
Array Management: Extract Field from Array
Uses the Column Array reference to grab the title key.
Get the data reference to this new array of ONLY the column titles.
CONTAINS Junction
Look through the new Column Array as the Values to search, and use the runtime.entities.Name that was pulled from your Parent workflow to check if that name exists as a Content in the Array (or whatever you're using as the new column name).
The SUCCESS state (the column name already exists in the array) is just a plain state with a title for my run log. This will cause the workflow to end in SUCCESS but to take no action.
The FAIL state (no column exists) is the MATCH junction that we already had set up, where if there is no column and if the value (e.g. "AZ") exists in the multi-select array, it adds the column. Otherwise, even if the column does not exist, if there is no matching multi-select value it does nothing.
Let me know if this makes sense and will work for you.
Cheers,
Genevieve
Genevieve P.
Re: Smartsheet Intelligent Work Management and McLaren Formula 1
Smartsheet is hands-down and 100% my favorite platform for the work I do. Thanks to this amazing tool, I have been able to build out many, many processes and solutions that not only assist me with managing everything within the departments I work for but also improve the type of support I am able to provide to the many departments. My solutions also provide our team members with the greatest gift of all, which is "TIME."
Now that folks from other departments are starting to see the power of what Smartsheet can do for them, they are coming to me to help them with building their own projects, which is a huge win. Smartsheet truly is the main driving force that is keeping our work aligned and efficient and, therefore, keeps us on track so we can continue to have our "Work With Flow" moments. Smartsheet is truly a game-changer for us!
Re: External Reporting
Then you should be able to publish the Report, and then they can view the information and nothing else.
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!
Andrée Starå
Re: Smartsheet Intelligent Work Management and McLaren Formula 1
Smartsheet is absolutely my tool-of-choice for helping people and teams make their processes more efficient. Using Smartsheet I've helped streamline intake processes, project management plans, team workflows, and more. Currently, I'm working on a team that oversees a portfolio with hundreds of projects, and we use Smartsheet every day to manage data, give project insights, and make sure our PMO org can Work With Flow.
