Show & Tell

Archives for March 2023

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…
New Community Member
Hello I am Kristen Jacobs, a Project Manager at Veradigm. I have been using smartsheet for about 3 years now. The tool never ceases to amaze me and what it can do. I look forward to learning more and utilizing all the cool features. I hope to become more interactive with the community as well and learn from others on how…
Column Properties Dropdown Formulas
Hello everyone, I'm hoping for some help. I have a series of codes that are tied to different strings of text. Here is an example. QA35: Please double check the instructions. In Smartsheets, I want to put the code QA35 in as a dropdown but have the copy tied to it, auto populate in the column. Is that possible? Please let…
New community member - introduction
Hello all - I'm a new Smartsheet community member and fairly recent adopter. I have a ton of background with Excel, databases, and SharePoint, so most of what I'm trying to do in SS isn't that difficult to figure out. HOWEVER, there are a few things I'm used to in other programs that I'm finding aren't quite as easy to do…
Help us celebrate one year of Member Spotlights! 👏🏻👏🏻👏🏻
Can you believe it was one year ago that your Smartsheet Community team said, "Hey, we need to do something new to recognize our awesome members who are spending their time helping others"? (We say this to each other a lot). And thus, the monthly Member Spotlight was born! Take a minute to reflect on the rock stars that…
2023: Powered by Purpose - a message from Smartsheet CMO Andrew Bennett
Hi there, As you've heard us say, our mission at Smartsheet is to empower anyone to drive meaningful change. Our Chief Marketing Officer, Andrew Bennett recently sat down to share his thoughts on how our purpose powers everything we do to amplify work that matters. Read Andrew's recent post, 2023: Powered by Purpose on…
Meet Katy Hall, our March Member Spotlight! 🎉
Scream, shout, let it all out for our Member Spotlight this month, Community Champion @Katy H! Katy is such a special, shining presence in this space, and you'll see what I mean as you read on. Katy lives in Los Angeles, California and is the Head of Product Management for ILLA Canna. As a startup, Katy was introduced to…
Oculus Quest 2 & Smartsheet
Hello Everyone, is there someone here who is using Smartsheet on OQ2 ? I cant figure out how to drag & drop elements in the card view :) With the latest FW update where you can use fingers to touch the Smartsheet tool seems much more friendly but still cant work with card view.
How to handle large projects
In this article, we show how to handle large projects by splitting the projects into subprojects while keeping coherence and synchronicity by linking cells between sheets as available in Smartsheet. This technique is safe and robust. The tracking of the project's progress remains fully automated. We have thus put the…
Introduction!
Hello all, I have been a Smartsheet Community Member for awhile now, but don't post a ton. However, I wanted to introduce myself and share a few of my accomplishments! I started my Smartsheet journey over 3 years ago (today I earned my 3 Year Anniversary badge in Smartsheet Community!) as an Administrative Coordinator at…

Best Practice

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…
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…
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…
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.…
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…
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…
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…
Lock or Store Date/Value Solution without using Zapier
Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it…
Use Javascript in Bridge to efficiently import data from an API
Hi all - I'm excited to share a custom Javascript solution with my fellow Bridge users. I am not a Jscript coder - all credit for this goes to the awesome @Nathan Lloyd at Smartsheet - Large Enterprise Technical Sales Engineer, who gave me the basis for this script at ENGAGE 2022. Thank you Nathan! In this thread I'll…
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…

Trending in Show & Tell

Add Help and Tips on our Dashboards
It would be wonderful if I could add a help tip right on the dashboard, so that when a user hovers or clicks an icon, the information is displayed, but the user remains on the page. Is that available?
October Question of the Month 💭 Join the conversation and receive a badge
Hi everyone, We're ready to kick off October with a new question and opportunity for you to earn some badges and points while getting to know your peers! What is one thing that scared you until you did it? Could be joining a new company, taking on a new project, sky diving or something else. Drop your answer in the…
Ambassadors group
@Alison Clancy can you help? I requested to join the group a few weeks ago but it is still pending, how long does it usually take? Thank you!

Show & Tell

Discussion List