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.

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…
Can't find or add a user
Hi, for some reason user rhea.tarin@weststarbank.com is not on the user roles and reports or seat types and true-up lists. We tried to add her using both of her emails and it looks like she was an existing user, and we cannot add her back or find her. Would you please guide us on a solution. Thanks,
March Question of the Month - Join the conversation and receive a badge
March is here, everyone! For February, we asked you to celebrate your everyday life achievements, and you blew us away with the responses. Not only are our members life-long learners that challenge themselves at work, but they are also passionate about their hobbies and crafts, and make the world a better place for their…
HOW TO: Smartsheet form/sheet to Sharepoint List (Including Attachments) Integration
With the help of ChatGPT, I just finished creating a Power Automate workflow for a Facilities Work order request. A user fills out the form, the row is created, and the Power Automate workflow copies the Smartsheet row AND ATTACHMENTS into a Sharepoint list. Source Sheet: Here's my actual Power Automate Workflow: Since…

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

Auto fill?
i use the app to fill out in smart sheets, but i been wondering if there is an auto fill feature since all my stuff are the same, the only thing that changes is the date, location and the persons name.
Meet Sarah Stone, our May Member Spotlight! 🎉
Some people find their calling by accident, and our May Member Spotlight @S.Stone is proof of that. She joined her current company before she knew what Smartsheet was, and today, she's the in-house subject matter expert. Additionally, she’s such an engaged Community Ambassador that she was nominated for this spotlight by…
Reintroducing Myself: Yvonne Smythe
Hi! My name is Yvonne Smythe, I prefer Yve (pronounced Eve). I am an existing community member who has and is still growing through some things (life). I’ve been doing a lot about recommitting to being visible, present and engaged. I am back and recommitting to the Smartsheet community because I’ve really missed yall. I…

Show & Tell

Category List

Discussion List

Categories

Popular Tags