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.

Any LMS/Content Managers using Smartsheet to track their content? Do you mind sharing?
My team manages training content for a specific part of our organization and we have content that can be as old as 2016 to as new as of yesterday. For a few weeks now, I've been trying to figure out a way to track "content" (right now, just LMS courses) we own in Smartsheet so I can share with leadership "This is…
Smartsheet Implementation: Overcoming Common Challenges in Change Management.
Hi everyone, I wanted to share some insights on how we’ve been using Smartsheet to tackle some of the most common challenges in change management. Whether you’re dealing with leadership alignment, struggling to keep projects on track, or facing difficulty engaging teams during a change process, I’ve found that having a…
Jivrus Data Studio Connector for Google Looker
Hi, In Looker's data source library there is a Smartsheet connector from Jivrus - Jivrus Data Studio Connector. Has anyone tried this connector and if so, what did you think? Thank you, Melissa
Calling All South Africans
Howzit everyone! Where are all the South African users? We're looking to hear from you and learn how you are using Smartsheet. What has been your biggest challenge with getting Smartsheet adopted and how have you bridged that gap? Looking forward to e-meeting you all!
Multi-Category KPI Tracker - Engage Template Contest Win 2023
Hello Community Forum! I won the template contest last year with my Multi-Category KPI Tracker which I have since updated and added on to. I would be happy to help anyone who has questions or wants to know best practices when using this template set. We use it in our Manufacturing department, but are developing it for the…
Smartsheet dashboard and data visualization
In my organization there is focus to get tableau to provide data visualization in a similar manner as Smartsheet. There are teams of people that are working to set up what I have and I’ve been able to do what tableau is natively intended to do. I’m not trying to toot my horn but at the same time I feel that Smartsheet is…
Cell Link issues? - helpful workaround tool
If you are experiencing any issues with cell links returning blank entries (when there is data present in the source file) the current resolution is to manually remove the link, save the sheet and then put the link back. Whilst this activity needs to be logged to Smartsheet Support and their experts are working on a…
(Solution) Using ZIP to get Per Diem M&EI Rates with Python
I've been testing new things with the Smartsheet API via python. Somebody down the road might find value with this if they want to build their own expense report system. It works by checking a column called "ZIP Code", and then looking at the bottom of the sheet for the latest entry, then gets the row ID. Once it has the…
Any material for Smartsheet vs ServiceNow SPM
Hi All, Does anyone have some info or resource on why go for smartsheet over SPM? Integration is possible, but i've been asked to justify it. Personally the UI of SPM is not great for me. Smartsheet is more user friendly. i like the automation of smartsheet (SPM has this too) and to be honest, i've been using it for a…
September Question of the Month - Join the conversation and receive a badge
Community, you always do such a fantastic job with these questions! Last month, we loved learning how some of you explain Smartsheet to the children in your life, and reading the many ingenious descriptions everyone came up with. Comparing it to Legos, Minecraft, magic notebooks, the classroom, and a friendly wizard were…

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…
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…
Formula To Indicate A Task Is Ready Because Predecessors Are Complete [Solution]
I have seen many posts about people wanting the ability to indicate a particular task/row is ready to begin because all of the predecessors are complete (many of them archived). All of the proposed solutions had short comings (e.g. only works on rows with a single FS predecessor with no lag). Here is my full solution to…
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:…
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…
URL Query String and CHAR() Function Helper Sheet
Greetings all, Because I grew tired of spending an inordinate amount of time piecing together URL query strings, I've compiled all of the UTF-8 character codes (that I came across) into an easy to use reference sheet. I've also added in a column for the corresponding CHAR() function codes and conditionally formatted the…

Popular Tags

Trending in Show & Tell

Hello from the Snow
Hello, I am a Program and Grants writing for MSU. I am a HUGE advocate of Smartsheet and thrilled to be using it again professionally!
Introduction
Hi my name is Freda Tesseneer. I am very new to Smartsheet so I could sure use your help. I work for Wanzl North America in Newton, NC.
November Question of the Month - Join the conversation and receive a badge [+bonus badge!]
Hello, hello. October’s question had a very clear trend — the Community members don’t fear challenges, change, feedback, or failure, because these are great ways to learn, get creative, and grow. Love that mindset! Who's ready for a new question, and a chance to earn badges and points while getting to know your peers? Read…

Show & Tell

Category List

Discussion List

Categories

Popular Tags