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.

Power of Communication - Alison Clancy
Hi everyone, I'm Alison, your Community Engagement Manager and also the Smartsheet Overachievers Program Manager. My power is the Power of Communication. What does your power means to you and how do you utilize Smartsheet and your power at work? I say this quote all the time because it's true: "If you want to go fast, go…
Smartsheet Community Team: Meet Genevieve 👋🏻
Hi, I'm Genevieve, your support Community Manager! Here are my five fun facts: I've currently been at Smartsheet for just over three years and knew nothing about formulas before joining…now I'm obsessed. I spent six years of my childhood in Uganda, but I'm Canadian (from Vancouver Island) and right now I live in the UK.…
Let's get the ball rolling! Say hello and share a new or favorite way you've used Smartsheet.
I'd love to get some initial conversation going in this group. Please say a quick hello to your peers and share either a new use you've found for Smartsheet recently, or your favorite thing you've created in Smartsheet overall. I'll share my favorite dashboard I've seen recently. This one was created by one of my…
👋 Hello from Kentucky! | IT & Manufacturing PM
The Professional Side: I’m a Project Manager in the Manufacturing sector, where precision and timing are the heartbeat of everything we do. My journey started in general project management, but I’ve found my true "geek gear" in the IT and Security space. I’ve made Smartsheet my "single source of truth" for keeping…
Has Anyone Found Success Using Both Smartsheet and Microsoft Power Platform?
Hi everyone 👋 I work for a mid-sized company (~5,000–6,000 employees) that’s heavily invested in Microsoft technologies — we use Power Apps, Power Automate, Power BI, and more. At the same time, Smartsheet is widely used across our teams, especially for project tracking and collaboration. Right now, we’re in the middle of…
August Question of the Month - Join the conversation and receive a badge
Hi Community, July’s question came directly from you, and honestly, I need to ask you for inspiration more often, because this was a fantastic idea! It was so great to check in and celebrate just how much you've accomplished in the first half of the year — from health milestones and new certifications to making time for…
Onboarding Ideas!
Hello there! My name is Esme, happy to join the Smartsheet Community! In summary, our organization has been utilizing Smartsheet in various ways with department-specific functions. I would like to create a solid onboarding foundation to help our new stars get familiar with Smartsheet and continue building on what our…
Dynamic Reporting to Report Scope within Reports is a Gamechanger!
I have several Dynamic Reports that I use regularly, especially for Portfolio Dashboards. Even though it was inconvenient to replace them with new reports using the Report scope: Programs, I am thrilled with the new possibilities with this feature. I have been using it to check specific rows in sheets in all of my existing…
New Member Introduction
Hello! My name is Lancy and this is my first day in the Smartsheet Community! I am a Marketing Financial Operations Manager. I've utilized Smartsheet for about 18 months. I use Smartsheet for budgeting and tracking purposes, new vendor tracking and PO tracking. I am excited to learn more about Smartsheet and its…
I'm so happy with this landowner contact log system I designed in Smartsheet
Managing landowner communication used to be one of the most time-consuming and fragmented processes at our company. We relied on Word documents buried in server folders. Logging and reviewing landowner details was slow, only one person could edit at a time, and getting a full picture of a project meant manually opening…

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

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…
I cannot log in
please see the screenshot attached. it asks me to contact the admin, but i´m the admin user so I tried to contact support team of smartsheet but i can not open a ticket/case

Show & Tell

Category List

Discussion List

Categories

Popular Tags