Best Of
Re: "Small gift - Great joy" from Smartsheet
Enviable swag @Gia Thinh ! Very cool…I'm hunting similar ;)
Keep up the contributions!
Re: "Small gift - Great joy" from Smartsheet
:) Sure, Will. Just one star more to become Ambassador!
I am happy to help people.
Re: Show Off your Smartpets
These were busy helping me work through as many “unanswereds” as possible tonight. Darcy Dog and Stella Luna Jeffords have it real tough
Re: Get your Brandfolder Badge 😎
I love how easy it makes organizing my company's imagery!
Re: Introduce yourself & get to know your peers!
Just looking through badges and I don't think I ever posted in the introduce yourself!
Hello Everyone I'm Dakota Haeffner,
I joined my team as a Smartsheets expert, specifically brought on board to build an intake solution but eventually got looped in to assist with the implementation, project management, and operation teams in finding effective solutions through Smartsheets. Throughout my journey, I discovered my passion for creating efficient formulas and went deeper into the world of coding, learning languages such as SQL and Python. This newfound knowledge has allowed me to develop Smartsheets solutions that have a significant impact on multiple teams within the organization. Aside from my professional achievements, I participate in races and lifting events as often as I can and love staying competitive. I am also blessed with a beautiful family. My wife, three kids, and two dogs bring joy and fulfillment to my life. I am proud to have been born and raised in Phoenix, AZ, and I appreciate the diverse culture and opportunities this city offers. Additionally, as a data enthusiast, I have a love for a well-designed graph. I am excited to continue my journey with Smartsheets and contribute to the success of our team and organization.
Celebrating Smartsheet Community
I got these excellent gifts last week in recognition of Leader status here and while I love the swag and badges, I want to emphasize how genuinely enriching it is to connect with all of you here! It sincerely makes my day when people here share for the greater good. Thank you @Arsineh @Alison Clancy @Rebeca S. and all of the Smartsheet Community team for making this an easy, fun place for us! I’m completely addicted to being here and can’t wait for Ambassador and beyond! (This may or may not be my 100th post 😎…only six-billion, forty-eight thousand, eleventy-two more to go until I change my name to Paul Jr.)
Much 🫶🏻 to you all!
Will
Re: Remove #NO MATCH return from VLOOKUP query
You can wrap your formula in an IFERROR function.
=IFERROR(Your formula, "")
Re: Smartsheet Forward Q2 2024: New ways to unlock actionable insights
thanks @Ben Canning, these are exciting updates and feature areas all around! Fun to explore and put to productive use!
Will
Re: How do I pull in a value using 2 criteria?
Thank you very much! The formula worked when I changed the 0 to a 1.
Follow up questions, some of the projects are not in my reference sheet, so I am getting an #invalidvalue. Is there a way to either return a 0 or remove these? I applied the formula to my entire column.
Re: How do I pull in a value using 2 criteria?
@Gillian C Thank you so much! You are a life saver!