Best Of
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å
Re: IF & ISBLANK with two Criteria in separate columns
The #INVALID REF error means one of the cross sheet references is incorrect. Were you receiving an error with the formula you originally posted? I copied the references from there, so they should be the same. One or more of these either do not exist or are incorrect:
{Section & Chapter Reporting Form Month}
{Select the reporting year.}
{Section & Chapter Reporting Form Unique ID}
Carson Penticuff
Re: RYGB Based on two date columns
Hi @MMorgan
Try this formula:
=IF(AND([End Date]@row > TODAY(), Status@row = "In Progress"), "Green", IF(AND(AND([Start Date]@row <> "", [Start Date]@row <= TODAY()), OR(Status@row = "To Do", Status@row = "Backlog", Status@row = "Planning")), "Yellow", IF(AND([End Date]@row < TODAY(), OR(Status@row = "In Progress", Status@row = "On Hold")), "Red", IF(AND(OR([End Date]@row = "", [Start Date]@row = ""), OR(Status@row = "In Progress", Status@row = "On Hold")), "Red", IF(AND([Start Date]@row = "", OR(Status@row = "To Do", Status@row = "Backlog")), "Blue")))))
Hope it works for you.
Gia Thinh
Re: Contact list in Smartsheet after importing data
Hi @JGarcia0703
You're facing a common challenge when importing contact data into Smartsheet. Since your list comes from Excel and Smartsheet does not automatically recognize names as contacts upon import, there are a few potential solutions.
Option 1: Use Data Shuttle to Update the Contact List (Requires Smartsheet Advance Plan)
- How It Works: You can configure Data Shuttle to update the contact column from your Excel file automatically.
- Pros:
- Automates the process, reducing manual effort.
- You can keep your list updated weekly without intervention.
- Cons:
- If full names are imported as text, Smartsheet will not treat them as contacts.
- Only email addresses will function correctly in a contact list.
- Requires a Smartsheet Advance Plan (not available in all accounts).
The image below is part of the Data Shuttle workflow that updates the contact list with email text.
Option 2: Import Excel Data and Manually Convert to Contacts
- How It Works: You can format names in your Excel file as
Jane Doe <jane.doe@somecompany.com>, then import the file and manually convert the column to a Contact List column. - Pros:
- No need for additional Smartsheet tools (like Data Shuttle).
- Provides both the name and email address.
- Cons:
- Requires a manual step each time after import to convert text into contacts.
- Still time-consuming on a weekly basis.
This link is my post on this method.
https://community.smartsheet.com/discussion/comment/369125
I put this demo dashboard to illustrate this method somewhere in 2023.
Option 3: Use the Smartsheet API to Update Contacts Automatically
- How It Works: You can use the Smartsheet API to programmatically update the column and ensure names are correctly formatted as contacts. This script could be triggered automatically when your list is updated.
- Pros:
- Fully automates the process.
- Ensures that names display correctly and function as contacts (for @mentions, update requests, etc.).
- Cons:
- Requires development work to implement an API script.
- Needs API access and permissions.
The code explained in the comment below does not update the contact list option. It adds contact value using the name and email information.
Best Approach Based on Your Needs
- If you have access to Data Shuttle, this could be a good option for automating updates. However, email-only imports may limit usability.
- If you don’t have Data Shuttle, importing an Excel file with properly formatted data (
Name <email>) and manually converting to contacts is an easy workaround. - If your team has API capabilities, using the Smartsheet API is the best long-term, fully automated solution.
Would you like help with an API script to automate this process? Let me know what works best for you!
Re: automatically apply =Min/Max of descendants formula to parent rows based on hierarchy number?
Oh, and you can alternately use the following:
=MAX(CHILDREN())
=MIN(CHILDREN())
Will yield same results as using descendants.
Ray Lindstrom
Re: Can I get help getting my colleagues logged in?
Thank you @Genevieve P.! That was the help I needed.
jmtrhydn