Best Of
Re: Celebrating the women of Smartsheet Community
How are you celebrating women this month, at work or in your personal life?
At my company, we are celebrating Women in Construction. We do this every year. We celebrate them by giving them shirts that say "Women in Construction" and telling them how they join their local Women in Construction Chapters. We also post group pictures of the various women that work at our facilities who work in the construction industry throughout the month of March. Many of the male managers and team members will post videos to say how thankful they are for the work the women do.
Angie Bryant
Celebrating the women of Smartsheet Community
Hello Community!
March is Women's History Month, and we want to shine a light on the amazing women here with us in the Community and all around us. Your contributions help make this a wonderful place for everyone, and we're grateful to have you here.
Recognizing women in the Community
Every month, we give the spotlight to outstanding Community members, and so many incredible women have been recognized. Take a moment to get to know them, learn from them, and visit the Member Spotlight topic for more!
- @Almonto1 here
- @Cherise Reguero here
- @Colleen Patterson here
- @Deanna Vandermeer here
- @Debbie Sawyer here
- @Ipshita here
- @Julia L Rumburg here
- @Julie Fortney here
- @Katy H here
- @Kelly Moore here
- @Lauren Dominique here
- @MelissaBoehl here
- @Monique Odom-Stearn here
- @Peggy Parchert here
Recognizing women all around us
Of course, there are also countless women in our lives that inspire us, and this month is a perfect chance to appreciate them and everything they do. Here at Smartsheet, we have a variety of initiatives to celebrate and empower women all throughout March.
For example, our teammate @Marcela ran an awesome project to recognize the women in our Costa Rica office. Everyone got the chance to nominate superheroes among their peers, and the nominees got a special shout-out highlighting their superpowers!
Now it's your turn
How are you celebrating women this month, at work or in your personal life? We encourage you to reflect on your own achievements, and the achievements of the women around you.
⭐️ In the comments below, celebrate the women that you admire and share what makes them so inspiring! ⭐️
Alison C.
Re: COUNTIFS and SUMIFS formulas with multiple criteria AND a dynamic date range in a sheet summary
The formulas look like they should be working as expected. If needed, make a copy of the source sheet and then delete a bunch of data to the point where you only have a handful of rows that you can manipulate to ensure everythign is working as intended.
Paul Newcome
Re: How to summarize and visualize sheet summary data of multiple sheets?
This feature has now been released! You can now create Chart Widgets from the top Summary rows from a Grouped Report. See: Charting using Grouping and Summary
Cheers,
Genevieve
Genevieve P.
Re: Trigger a Checkbox when the System time matches a Service Level Time
Thank you @Kowal, I think that may just work.
It's a long way around but that may work. Thank you so much for the prompt responses and support.
Allan Moyo
Re: Happy 10th Anniversary Community + Giveaway!
When someone ask me to explain smartsheets I usually say, "Smartsheets is excel on steriods but it's safe for kids." 🤣
I don't know if Smartsheets would want to sign off on this description but it's quick and effective to get the point across.
Dakota Haeffner
Re: downloaded RACI template locally (IC-Simple-RACI-Matrix-11490) Click here doesn't work
Thank you! Great answer!
jstrickland
Is it possible to use a workflow to import a formula?
Hi ,
I'm quite new to Smartsheet and have been playing around with it,
I recently created the following workflow to "sort of" import a formula when another column gets updated
the idea behind this , is to update a cell after the new size has been added.
it seems to work to some extent how ever it leaves a ' before the formula , and I have to manually remove it.
My 1st thought was to create a formula where if the Colum is blank it mustn't do anything and only update when the new size is entered.
IF(ISBLANK(Mailbox Size after Archive(GB) (WHOLE NUMBER)@row), "",=[Mailbox Size after Archive (GB) (WHOLE NUMBER)]@row
Kind Regards
Brandon Austin
Brandon Austin
Re: Percent Complete Based on Checkboxes
Try this:
=Sum(COUNTIF([IDR 2 Completed]3, 1) + COUNTIF([G2 Completed]3, 1) + COUNTIF([IDR 4 Completed]3, 1) + COUNTIF([G4 Completed]3, 1)) / 4
Matt Lynn ACT
Smartsheet API Docs Site is Getting a Major Upgrade!
Hello, Smartsheet Developer Community!
We're excited to share about significant improvements coming to our Smartsheet API documentation site! Get ready for a smoother, more interactive experience.
What's Changing?
We're moving our Smartseet API documentation to a brand-new, revamped site! Here's what you can look forward to:
- New Home: https://developers.smartsheet.com/api
- Timeline: We plan to switch within the next two weeks and will post a second announcement to notify you on that day.
- Awesome New Features:
- Modern & Responsive Design: Enjoy easy viewing on any desktop, tablet, or mobile device.
- "Try-it" Functionality: Test API endpoints right in your browser! No more switching between tools.
- Dark Mode: We've got you covered if you prefer a darker interface.
- Easy Feedback: Share your thoughts and suggestions directly on any page or code example. Your feedback is invaluable!
- Expanded Code Examples: You'll find more examples in a broader range of programming languages, making implementation even easier.
What You Need to Do (After Launch):
- Update Your Bookmarks: Once the new site is live, please update your bookmarks to the new URL: https://developers.smartsheet.com/api
- Update any links: if you have any links to the old Smartsheet API documentation, please update them.
Stay Tuned!
We'll post another announcement here in the Community when the new site officially launches.
We've worked hard to make this upgrade a significant improvement for you, and we can't wait for you to experience it!
Jim Hinkey