Best Of
Re: Introduce yourself & get to know your peers!
Hi, my name is Kendra, and I'm finishing up my first year as a Project Manager. I'm looking forward to getting started on my second. I am a PM for an HR consulting department within a payroll company. I've spent the last year cleaning up numerous broken or non-existent processes, streamlining reporting, and learning a great deal about Smartsheet. I'm looking forward to learning more this year and taking on a more strategic role.
Kendra C
Re: Formula to add Months to Date
@heyjay This one will allow for more than just 12 months and can also handle negative months. I tested it out to +/- 60 with no errors, but I feel confident it will work for any number as long as it is within the date constraints on the back-end. I can't remember exactly what they are, but there is a date that is too far in the past to be recognized as a date and one in the future as well. As long as you stay within those (whatever they are), the below should work for you.
It is essentially an Excel "EDATE" replacement.
=DATE(YEAR([Original Date]@row ) + (FLOOR(MONTH([Original Date]@row ) + ([# of Months]@row - 1), 12) / 12), IF(MOD(MONTH([Original Date]@row ) + [# of Months]@row , 12) = 0, 12, MOD(MONTH([Original Date]@row ) + [# of Months]@row , 12)) + IF(IF(MOD(MONTH([Original Date]@row ) + [# of Months]@row , 12) = 0, 12, MOD(MONTH([Original Date]@row ) + [# of Months]@row , 12)) < 0, 12, 0), DAY([Original Date]@row ))
Paul Newcome
Re: User Activity
I usually go through my comments for this, but that can get a little tedious if you are a more active user. You can also use the search feature if you remember some key words. The last option that is more proactive than reactive would be to bookmark posts you may want to circle back to, but that's assuming you know you are going to want to revisit it before you navigate away from it.
Paul Newcome
Re: User Activity
Two ways that I know, click you profile picture then "My Posts", the second one, is click your profile picture, click your user picture (larger size this time) then click "Comments" to see what you have contributed.
Alex Argumedo
User Activity
I've been wondering about this for awhile, is there a place where you can find your user activity for any comments, or questions you've helped answer etc.. I know there is a Activity in your Profile for badges and achievements but im looking for your activity within the community.
Ex: I've answered a question, and now its not showing in the Unanswered, how can i find that question again?
I feel like there is a very obvious answer here… i know i can wait on the notification but sometimes for some reason, i dont get one. I also have ALL notifications turned on
Cayla Davis
Re: Phone number validation won't allow all zeros
If you set 000-000-0000 as the default value it can still be accepted.
Jgorsich
Re: [GIVEAWAY] Win a Smartsheet Certification
What’s ONE reason getting certified would be a great next step in your career?
Smartsheet has been one of my favorite tools for managing people, projects, and change. Over the years, I’ve built dashboards with dashboards built in, led 300+ team members through data-driven improvement, transformed manual steps into measurable clarity, and connected data points into a unified ecosystem to eliminate silos.
Every certification I’ve earned has strengthened not only my skills but also my ability to develop others - turning structure into strategy. The new Smartsheet Professional Certification represents the next step: validating years of hands-on innovation, expanding the reach of that knowledge across teams, and continuing to grow with Smartsheet.
I was recently made a Smartsheet System Admin - a non-IT member stepping into a new frontier. Earning this certification would help me continue doing what I love most: developing others, improving processes, and inspiring fellow Smartsheet enthusiasts to see structure not as limitation, but as freedom.
Personally, I’ve always loved peeling back the layers of the “onion” - uncovering how things work, solving puzzles, and finding smarter ways to connect the dots. That’s what makes Smartsheet so rewarding: there’s always another layer to explore, refine, and share. Thank you.
MMcLain
Re: [GIVEAWAY] Win a Smartsheet Certification
Completing the certification for Smartsheet professional would help solidify my knowledge of the application. Right now, I am the lead Smartsheet user for my company and provide help with Smartsheet applications through out all of our sectors. Achieving this certification would allow me to expand my knowledge to support my colleagues and continue to provide process improvement and project management solutions for the enterprise.
jturnerNG
Re: [GIVEAWAY] Win a Smartsheet Certification
I consider learning and integrating Smartsheet into our daily workflows and project planning a significant achievement. Although the tool has been around for a while, its popularity has grown recently, and I truly appreciate its powerful capabilities, especially the automation features that make my work much more efficient. Earning the certification feels like a formal recognition of the work I’ve already been doing. In fact, I’m well known within my company for my expertise in Smartsheet
Deepthi Koppula
Re: Parent/ Grandparent Cell Value
WOW that was way easier than I thought it would be!! That works thank you both
Liz Wallace