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.

Hello everyone! I'm new here and eager to connect
Hi, I'm Tony and I'm excited to start interacting here more and learning from y'all! I'm in San Diego currently and have had many different jobs and experiences leading up to now. From teaching music, being a range hand, ammeter developer, to my current role as a Manager of PMO Portfolio & Technology. I tend to bring…
Introduction
Hey everyone, I have been a user for over 6 months but just now getting around to doing a formal introduction. My company has been using Smartsheet for about 2 years now to build high level reports, dashboards, and proactively management a huge portfolio of construction projects. I really enjoy getting to learn the advance…
Introduction - Looking forward to collaborating
Hello Community, My name is Derek Semmler and I am the Sr. Director of IT Enterprise Applications at a biotech company. Prior to joining my current company, I spent 20+ years with a large pharma company and then four years with a CRO - neither of which were open to adopting Smartsheet. Much to my surprise, my current…
Hello!
Hello, I'm new to the community. My name is Tiffany and I live in the Indianapolis area. I have been using smartsheets for almost 3 years and it has been a game changer. I LOVE smartsheets and I know I am only using a tiny percentage of its capabilities. I can't wait to learn all things smartsheets!
Merged: New Idea: Add tabs to a sheet
This discussion has been merged.
Hello Community
I'm JZ, working in smartsheet (and loving it) since 2011. My latest work is focused more on Project Management and Art Outsourcing, along with Art Resource Management. As you may notice, those are some heavy 'machines' when it comes to keeping all the parts organized! Smartsheet continues to be my goto, and thankfully is…
Parallel applicant tracking system in Smartsheet
I love how robust Smartsheet is and what wonders it can do. We recently took a challenge from the HR team and built a parallel fully functional applicant tracking system in Smartsheet, which replaced their legacy ATS. Check out the details here - https://www.linkedin.com/feed/update/urn:li:activity:7087444898932498433
Streamlining Production Planning: How Smartsheet Integration Saves Time and Boosts Efficiency
One of our clients faced the challenge of their planning team constantly needing to check a shared Google sheet throughout the day. The process of reviewing the data multiple times and manually updating the schedule was time-consuming and prone to errors. Missing any crucial information could potentially disrupt their…
Smartsheet Profile
Okay, first I am a contractor. I work for a Staffing Agency, and the client is Medtronic. Now, I am trying to be proactive here (FL is a right to work state). I have my current Smartsheet account (and community profile) through my current job at Medtronic. Based on someone's suggestion (which was for getting certified so…
Project Metrics You Might Not Think to Add to Your Dashboard
When building a project dashboard in Smartsheet, it's important to consider a wide range of metrics that provide comprehensive insights into your project's performance. Here are some project metrics that you might not immediately think to add to your Smartsheet dashboard: Customer Satisfaction: Include metrics related to…

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

Meet Jacob Stey, our November Member Spotlight! 🎉
Come say “hey” to Jacob Stey (@SteyJ) because he’s our November Member Spotlight! 👋🏻 You may have seen this Community Champion at ENGAGE Seattle or helping others around the platform - now’s your chance to hear his “Smartsheet Story” straight from the source. Jacob is a System Administrator at Patriot Group International…
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.
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!

Show & Tell

Category List

Discussion List

Categories

Popular Tags