Girls Who Code is an international non-profit organization dedicated to closing the gender gap in technology and changing the image of what a programmer looks like and does. The organization does more than teach girls to code; they’re building a global movement to change culture and challenge systems that have kept girls…
Puppies Behind Bars (PBB) trains incarcerated individuals to raise service dogs for wounded war veterans and first responders, facility dogs for police departments, and explosive-detection canines for law enforcement. Puppies enter prison at the age of 8 weeks and live with their incarcerated puppy-raisers for…
Located in central Arkansas, Since being founded in 2007, City of Hope Outreach (CoHO) has supported and empowered hundreds of under-resourced individuals throughout the State of Arkansas. I worked with them in college and saw the impact on the families and individuals in my community, it is a truly special place. The…
The Fisher House Foundation builds comfort homes where military & veteran families can stay free of charge, while a loved one is in the hospital.
Mission Statement: "The mission of Dress for Success is to empower women to achieve economic independence by providing a network of support, professional attire and the development tools to help women thrive in work and in life." They collect donations of professional wear and pass them on to women who need them. Often…
I am imagining some very cool things I could do if I just had a little boost with Bridge and SharePoint. I would very much like to automate Get List and Get List Items to put SharePoint document library metadata in DataTable or even just a sheet, in order to dashboard on the state of that document library and automate…
At the US Grand Prix we removed our logo from the McLaren F1 cars and replaced it with a nonprofit: The Hidden Genius Project. But we didn't stop there. Beyond providing awareness and visibility into the work this incredible nonprofit is doing we wanted to provide them the work management training and resources through…
I built a Smartsheet App called API Retriever that allows you to connect to any API, pull your data, and import it into your sheets. Check it out at https://www.apiretriever.com I'm happy to assist if you need any help creating a request. Let me know if you have any feedback or need any assistance!
I've volunteered for the ICRH several times, and they are an amazing organization. They are really committed to helping the people of our community find a way out of homelessness and provide shelter for those in need during the coldest months in Michigan.
WELCOME TO SECOND CHANCE FARM; ABOUT OUR FARM The animals we take in are often deaf and/or blind while some have other challenges. We are devoted to giving Second Chances to those that may otherwise be overlooked. Many of our animals become eligible for adoption. Those who cannot, stay at the farm and live out their lives…
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.…
