Hello! I'm hoping that this community can help me get up to speed with Smartsheets - I have more expertise in Excel, but sometimes that expertise gets in the way with a program that's just similar enough to be frustrating, like this one. I'm hoping to gain enough fluency with this program to be able to use most common…
I am based in Seattle and been a SmartSheet user at a nonprofit since 2018. I finally discovered courses in SmartSheet University (although had the chance to take an in person fundamentals course early on) and earned the CoreApp and WorkApp badges! I am currently leading a team working with a SmartSheet consulting team to…
I've created a successful integration from Bridge to a Sharepoint Time Tracker site. There are a number of lists on this site containing Time Card entries and Time Categories. TimeCard - contains all time entries for people including myself TimeCardTest - contains time entries for people excluding myself Time Categories -…
I'm passionate about a couple of organizations. Habitat for Humanity is one, and I usually assist annually in the building of a home (in the past I was involved with a coalition that built one home a year for 12 years). I also believe in making sure no child goes hungry, and as such I donate to a Power Packs Program that…
In 2006, my mother co-founded Casa Valentina to fill a huge gap in the Miami foster care system. When kids in foster care and group homes reach age 18, many times they are just sent out into the world. Growing up in foster care unfortunately means that many never learn the life skills, social skills, and basics to…
A non profit that I am passionate about is the EveryLife Foundate. I found out about EveryLife in 2010 after my brother, Erik, was diagnosed with ALS. They provided us resources on what we could do to apply for FDA assistance and gave me a way to give back even after Erik passed. Everylife not only lobbies for legislative…
I don't believe there is a save for later option in forms. I hope I am wrong! :) What is the best way to allow for multiple people to update information in a form? I really don't want to create 4 forms based on the team in the organization that will need to fill it out. Am I missing any better alternatives?
HOM CASA was established with the primary focus of cultivating a group of volunteers to serve as non-attorney officers of the court who advocate for the best interests of children in foster care due to abuse or neglect. CASA volunteers are dedicated to one child at a time (sometimes siblings) in order to establish a safe…
I have the Power of Leadership! Is your power something you intuited or something you learned? Something I learned! Describe a time when you utilized your power and Smartsheet to succeed at work? used my power to help develop a new way to manage project intakes and governance. Fill in the blank: I feel most in my power…
As a project manager, I've used Smartsheet for years, but never for more than a Project Plan. In the past year my organization is now an Enterprise customer, and we are building two control centre systems with the help of a 3rd party consulting team. In my effort to effectively mobilize the product, I created the following…
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…
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…
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…
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…
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.…
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…
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…
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:…
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…
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…
4, 6, 8, 10, let’s go @Jason Tarpinian! We’re so happy to feature this Community Champion as our October Member Spotlight. Jason is a Project Manager of Technology at Sevan Multi-Site Solutions, and calls Minnesota home. About seven years ago, as an Assistant Project Manager, he first used Smartsheet to manage hundreds of…
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…
During September, you shared when and where your mind works best. Of course you all had unique preferences — early birds, night owls, the office, home, white noise, mowing the yard — but you also had quite a bit in common. So many of you get your best ideas while being active, in the shower, or after a nice cup of coffee.…
