Now, let us get to know you!

--- Introduce Yourself
--- Answer the Question of the Month
--- Connect with your Peers

Show & Tell

Whether a promotion, Smartsheet solution, best practice or badge - Share, celebrate & cheer on each other!

Member Spotlight
Get to know outstanding members of the Community.
SmartStories
A video series celebrating the vibrant voices of the Community.

We want to hear from you: How are you using the Smartsheet connector for Claude?
Hello, The Smartsheet connector for Claude was recently released, and we'd love to hear how you're using it — whether you've made it part of your regular workflow or just kicked the tires once. Drop a comment below, or share a short video testimonial, with your experience. Specific use cases are especially helpful. Share…
April Question of the Month - Join the conversation and receive a badge
Happy April, Community! We loved last month’s question because it was suggested by YOU, and as expected your responses were phenomenal. We’ve carefully read through all of your insights, and want to thank you for taking the time to share them with us. Pro tip: Feedback is always welcomed. Beyond this month you can continue…
Introduce yourself & get to know your peers!
Hi there, Get to know other members in the Community and take a minute to introduce yourself in the comments below. Feeling at a loss for words and need a little inspiration? Tell us where you’re from, your role, how you use or hope to use Smartsheet and a fun fact or two about yourself. (We love to learn about your…
Nominate Peak Humans & get a badge!
Hi Smartsheet Community, We loved learning about what operating at your peak looks like for you, and now, we want to give you the opportunity to recognize and celebrate others, and earn cool badges as you do it 😉 The Operate at Peak Human campaign is a celebration of humanity. Recognize someone who does a great job in any…
Smartsheet Community Team: Meet Georgie 👋🏻
Hi everyone! I’m Georgie and I’m the newest member of the Smartsheet Community Team! Fun facts about me: My dog, Daisy, only has one eye and although she’s 12 years old, I still get asked frequently if she’s a puppy as she has a very youthful look about her. I keep asking her to share her secrets, but she’s selfishly…
Recoginition of an amazing SmartSheet Champion
I would like to recognize @Paul Newcome who has been so helpful, patient and amazing with trying to help me with my issue with my Smartsheet. His true diligence on trying to help me find a solution was amazing and effortless. Thank you Paul!
Not able to register for Smartsheet Core Product Certification
Hello, I have been using Smartsheet since September 2024 and am planning to take the Core Product Certification. I have hands-on experience building forms, update requests, automations, trackers, and custom formulas. I am currently progressing through the Builder Certificate of Achievement (BCoA) learning path in…
Seat type automatically changed from "Member" to "Viewer"
Hi Everyone, Is something going on with smartsheet. For some users in my organization, the seat type has been automatically changed from "Member" to "Viewer". Additionally when I raised a support case, no one has been assigned to it yet.
Simple Star Rankings
Here's a single formula to show star rankings (including half stars) for anyone who's interested: =IF(ISBLANK(Rank@row), "", IF(Rank@row = 0, "☆☆☆☆☆", IF(Rank@row = 0.5, "⯪☆☆☆☆", IF(Rank@row = 1, "★☆☆☆☆", IF(Rank@row = 1.5, "★⯪☆☆☆", IF(Rank@row = 2, "★★☆☆☆", IF(Rank@row = 2.5, "★★⯪☆☆", IF(Rank@row = 3, "★★★☆☆", IF(Rank@row…
Smartsheet- getting error repeatedly when trying to add a Sharepoint link to dashboard
This is occuring when the user is trying to add links to a dashboard widget. This is also happening for any links being added. User has Admin permissions and has added other links. Has anyone else experienced this?
How to troubleshoot this issue if not network related and only some users get this message
Reactivating Business Plan: Will my existing sheets and permissions be fully restored?
Hi, I have a question regarding reactivating my Smartsheet subscription. Previously, our team used a Business Plan with one Admin (Owner) account and two additional licensed users. We canceled the annual subscription some time ago, so our account is currently inactive (or in read-only mode). If I log in as the original…
I want to leave the group I’m currently part of and create a new, separate subscription.
Hello everyone, I am currently subscribed to a group, but I want to leave it and pay for a separate subscription to create a new group. However, I’m unable to do so. Even the owner of the current group is trying to remove me, but it shows that the Hotmail account cannot be deactivated. What is the solution?
Backup all Workspaces???
Are you wondering how you can backup all workspaces as a system admin? You can't! If you want to save time and your sanity, please read and upvote my idea here: https://community.smartsheet.com/discussion/146098/backup-all-workspaces?utm_source=community-share
How to contact SmartSheet if an account is blocked?
One of our clients is getting an error when logging into Smartsheet: "Access to your account is blocked due to a billing issue. Please submit a ticket." -When we try to submit a ticket, it doesn't go through. -When we try to contact support from the website, it always asks us to sign in, which we can't do since the account…

Best Practice

Formulas for Calculating Time
I have decided to create a post that consolidates all of the different time based solutions that I have put together. Some of these solutions can be made more efficient or condensed into fewer but larger formulas. I am still going through these working on making them more efficient and tweaking them, but all of them have…
Work Breakdown Structure (WBS) - Column Formula Configuration
Hello Everyone, Recently myself and two fellow Smartsheet Sales Engineers, @Lea Gikas and @Dave Stanley got together to create a WBS solution powered by Column Formulas. We wanted to provide the resulting configuration to the community in case some may find it helpful in executing project management solutions, this…
Quick way to copy formulas across sheets I found
Problem: I had the need to copy a list of 26 formulas to 56 sheets maintaining the formulas for each sheet. to increase the data collection across the sheets. All sheets have the same column names. Smartsheet defaults to saving the end result, and doesn't offer the ability to just copy the formulas from one column in one…
Speedometer Chart: Core Product
I've noticed a few people asking for Speedometer Charts in Smartsheet, so I figured I would go ahead and publish this solution that I developed. It was some years ago, so there may be better ways and / or more efficient formulas, but this should at least help get everyone started… A few notes to kick things off… This…
Daily Update Solution without the need to open the sheet, use Zapier, or similar
Hi everyone, Happy New Year! I hope you're well and safe! I've developed a way to use the newly released Record a date feature to update sheets with today's date automatically without the need to open it or similar. 1. Add a so-called helper column. (Date). We can call it Today Helper and add a date before the current day.…
For Every one want to have More color symbol for health Status column.
Dear Community Memebers, I saw many equations asking to have More color symbol for health Status column, so i added this post to be a simple reference to solve this issue and with your help and comments we can develop it to match the most of your wishes. the following screenshot shows the color reference you can use it in…
Combine emails into a multiple-contact column / multi-contact column
Multiple-contact columns can be problematic to use in Smartsheet. Namely, they cannot be "put together" with a formula. There's many use cases where you need to build multiple contacts into a cell based on criteria/lookups, but there isn't a way to do that in native core Smartsheet. There is, however, a couple of methods…
INDEX and MATCH across two sheets: a detailed explanation
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference cells from another sheet by…
Auto-Create Child Rows WITHOUT Bridge or API
This initial solution is based on form submissions being made and each form submission triggering the creation of a set of "template" child rows per submission WITHOUT the need for a 3rd party app, the premium add-on Bridge, or the API. So if your form submissions look like this: Your working sheet could look like this:…
Pre-Filled Forms Using URL Queries: Tips and Tricks
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…

Popular Tags

Trending in Show & Tell

Recoginition of an amazing SmartSheet Champion
I would like to recognize @Paul Newcome who has been so helpful, patient and amazing with trying to help me with my issue with my Smartsheet. His true diligence on trying to help me find a solution was amazing and effortless. Thank you Paul!
Not able to register for Smartsheet Core Product Certification
Hello, I have been using Smartsheet since September 2024 and am planning to take the Core Product Certification. I have hands-on experience building forms, update requests, automations, trackers, and custom formulas. I am currently progressing through the Builder Certificate of Achievement (BCoA) learning path in…
Meet Cayla Davis, our April Member Spotlight! 🎉
Some people are natural community builders, and @Cayla Davis is one of them . Her energy around collaboration is contagious, and why she was inducted into the Community Champions this year. If you need a boost of inspiration, read her member spotlight and get to know her Smartsheet story. Cayla is a Global Technology…

Show & Tell

Category List

Discussion List

Categories

Popular Tags