Best Of
Re: February Question of the Month - Join the conversation and receive a badge
I'd introduce a badge for users based on the number of Smartsheet assets they create or own.
Something like Creation Commander
For example, badges could be awarded at milestones such as 10, 100, 1,000, 2,000, 3,000 assets, and so on.
This would be a fantastic way to recognize and celebrate the contributions of our community members in their respective companies.
Michelle Basson
Re: February Question of the Month - Join the conversation and receive a badge
I would suggest a group of people specific to helping others with formula — such as The Formulators!
Bruce Case
Re: Dynamic Dashboard Template Customization
Hi @Rose Howard
In the demo dashboard below, I customized the template to add a filter to select a project name and show the selected projected row data. (In your case, the Project Name would be the Last Name.)
To customize the template, I did the following.
First, I added one sheet and two reports.
Those three are equivalents of one sheet and two reports for the original template's region filter.
The Active Project- Project Filter uses the Project sheet's Max Row Helper column (As shown below) to extract one row to show as a "Filtered Project", as shown in the above dashboard. (The report directly uses the Portfolio Summary sheet's "Project Helper" column, but the column is updated with the Max Row Helper.)
The "Current Filter - Project" report shows the current filter for the project choice, as shown in the top right corner of the demo dashboard.
This "Project" sheet has an identical structure to the Region sheet.
Its form is attached with a web widget in the top middle of the above dashboard.
In the "Portfolio Summary" sheet, I added the "Project Helper" column with a similar formula as the Region Helper column.
=IF([Project Name]@row = "Summary", "", IF([Project Name]@row = INDEX({Project Range Project}, MATCH(true, {Project Range Max Row Helper}, 0)), 1, 0))
So, the whole process is as follows.
- The form in the dashboard adds a project name to the Project sheet.
- The new row will be flagged in the Max Row Helper column.
- The corresponding row with the same project name's Project Helper column got flagged.
- Two reports for a project use the flag to filter a project.
- The dashboard displays those filtered reports.
Current User Approach
Since you know how to use a report to select the current user filter, you just have to create a report with relevant data with the current user filter. (Make sure to set the Viewer Mode to "Their own perspective"
When I log in as "App".
When I log in as "Demo".
Re: Community Corner Newsletter [February 2025]
I am so excited to be part of the most recent class of Community Champions along with my 18 other classmates.
Also - to the community as a whole, I am honored to be able to meet with and help so many of you. If there is every ANYONE who wants to troubleshoot something, review a formula, or whiteboard a solution, I am so happy to meet with you on zoom. My calendar link is in my signature. :)
Re: Core App Skills Badge not visible
:( I heard no more credly, but thought the community badges would continue.
Congratulations though!
KPH
Community Corner Newsletter [February 2025]
Hello neighbors,
It's been a while since I last wrote to you personally, I've missed you! I hope you are enjoying another edition of our Community Corner. Many thanks to @Arsineh, our Community Director and the author of our last edition where she told us about her travels to Italy and Switzerland, what beauty! If you missed January's Community Corner you can read it here.
As you already know, outdoor adventures and social work are some of my great passions. Last time I showed you pictures of the beach cleanup, this time we went from the sea to the mountains. Read to the end to learn more about my latest adventure in the mountains!
Community highlights
Help us welcome some of our newest Member introductions in Show & Tell or look through the Trending section for more ways to connect.
Say hello to these Community Members 👋🏻
You can find more new members and say hello here.
---
Ideas & feature requests (recently reviewed and updated by our Product Team)!
What’s it going to be? Head to the Smartsheet Product and Ideas Topic to share and vote on ideas.
- Rearrange items in collections - Available Now!
- Don't allow editing of workspace permissions when sharing an individual item - Available Now!
- Make Formula Window Adjustable - On Roadmap
- Unhide specific columns on a sheet - In Early Adopter’s program
---
Community updates
In Case You Missed It (ICYMI)
Jumpstart 2025 Recap
Relive the fun of our virtual Community party
February Question of the Month
Share your answer by February 28
New Class of Community Champions
Upcoming in-person User Groups
Brand Collective Podcast
This episode - Learn about creator marketing!
---
Pass the mic 🎤 Community Champions
Community Champions are members who demonstrate product expertise and generosity in sharing best practices and support with others on the platform.
“When I was new, I used to post a lot of questions which were answered by experts. When my knowledge evolved, I felt that it was my turn to give it back to the Community. I still need to rely on the Community for help sometimes, and they welcome me back with open arms.”
- @Amit Wadhwani , Vice President of Operations at Ignatiuz, Inc. and Community Champion (Learn more about Amit in his member spotlight here)
---
Member Appreciation
See Activity feed for more
This month's leaderboard
Member spotlight
This month, we have not one member, but a whole amazing group of Community members on the spotlight — our newest Community Champions! They join 50+ other Champions that generously share their product expertise to help others. 🤩
@=Chris Palmer , @AravindGP , @DKazatsky2 , @Gia Thinh , @Joe Goetschel , @John_Foster , @Kerry St. Thomas , @KPH , @Leroy Noriega , @markkrebs , @Mark.poole , @Matt Lynn# , @Michelle Choate 2 , @NickStaffordPM , @Philip Robbins , @Protonsponge , @Rich Coles , @Sam_Harwart , @Will Duplex
Do you know someone in the Community who should be next month's Member Spotlight? Nominate them here.
---
Overachiever's Motivation Mix
The Smartsheet Overachievers are here to give you the songs that will keep you going and keep you achieving! Here’s what’s on the playlist right now.
Bad Bunny - NUEVAYol
“Debí Tirar Más Fotos is my favorite album of 2025 so far. I think Bad Bunny is a genius at mixing different traditional Latin genres together, like dembow and salsa, and modernizing them in a way that speaks to multiple generations. This song kicks off the album and from the start, it’s a rollercoaster of endorphins and makes you want to dance! I’m also from the east coast originally and it makes so many great references to New York and the music culture there that make me smile. NUEVAYOOOOOOOL!”
- @Alison Clancy, Community Engagement Manager II at Smartsheet + Overachievers Program Manager
---
More about Marcela:
In January, the Smartsheet Social Responsibility Pillar went on a mountain hike to the burns on the slopes of the Turrialba Volcano, located in the central volcanic mountain range of Costa Rica, a relief composed of seven volcanic massifs, 4 of them active.
The objective of this charity hike was to collect school supplies to help children at social risk with their entry to classes this February 2025. The camaraderie, the incredible views of the volcano, and an awesome two-rooted tree made this activity very special. In total, we benefitted 50 children for their return to school!
And you, would you dare to be so close to a volcano?
---
Give us your feedback
Have ideas for the next Community Corner? Leave your thoughts in the comments!
Note: Unfollow this Topic if you'd no longer like to receive alerts. We'll miss you!
Marcela
Re: Why has my Core App Skills badge not shown up on my profile?
No problem! It can probably prevent others from being confused.
Freda
FTesseneer
Re: February Question of the Month - Join the conversation and receive a badge
I'm honestly impressed by the creativity of some of these badges already made by the Smartsheets team. A Community Mentor badge might be cool to have. Basically add a button to peoples profiles so others can nominate them for it. It might be nice to follow people too. Some of these folks have great post all the time.
Dakota Haeffner
Re: Update one sheet based on two columns from another sheet
Hi Peggy,
Thank you for your help, but I am running into an issue. I put in the same exact formula with basically the exact sheet you made just to test it out and I keep getting the 'not in sheet' line instead of a check box
Am I missing another reference where {Review Sheet - Task Number} is?
EDIT** I figured out it out, I had to remove the "{Review Sheet - Task Number}, 0))" part of the formula and it worked, I think it was the way you nicknamed the range.
santiago.rendon
Re: Method to limit attachment types?
Hi Lorenia,
To add to Pauls excellent answer.
You could also add a checkbox or similar that indicates the type the user attached or that they acknowledge that they've added the correct type.
Make sense?
Would that help/work?
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Andrée Starå