Best Of
Re: Core Product Certification
To be candid I would take it today and see if I pass it, assuming you have gone through the training. If you fail you can rebuy the course before the offer expires, you have 60 days to take it. I failed my PM exam by 2 points, I then went over the material again with a better understanding of what the test was asking. I passed on my second try.
Leroy Noriega
Core Product Certification
Hi all - I am planning on getting Core Product Certification. Besides the training sessions Smartsheet offers, any recommendations on preparing for this test?
Thanks!
Re: How to simplify SUMIF formula
Hi Kowal and Kelly,
Thank you for taking the time to work through a couple of solutions. With some trial and error, we've added two rows to the top of our sheet; a row for the number corresponding with the month and a row for the year. After we update the references in the January column, we can then simply drag across and the formula updates for the rest of the year. So far, this is working well for us, but in the meantime, I'll also check out the Pivot App.
=IF(SUMIFS({USD Amount}, {Date}, AND(IFERROR(MONTH(@cell ), 0) = January3, IFERROR(YEAR(@cell ), 0) = January4)) = 0, "-", SUMIFS({USD Amount}, {Date}, AND(IFERROR(MONTH(@cell ), 0) = January3, IFERROR(YEAR(@cell ), 0) = January4)))
Jo Kuhn
Re: Formular Workday Count
Assuming your sheet is configured so that work days are Monday, Tuesday, Wednesday, Thursday, and Fridayβ¦
You start with Thursday 4/24/25.
Add 1 day and the due date is Friday 4/25 (1 work day after 4/24)
Add 1 more day (2 work days total) - Monday 4/28 as Sat 26 and Sun 27 are not working days.
Add 1 more day (3 work days total) - Tuesday 4/29
Add 1 more day (4 work days total) - Wednesday 4/30
Add 1 more day (5 work days total) - Thursday 5/1
Add 1 more day (6 work days total)- Friday 5/2
Add 1 more day (7 work days total) - Monday 5/5 (again skipping Sat and Sun)
Add 1 more day (8 work days total) - Tuesday 5/6
Add 1 more day (9 work days total)- Wednesday 5/7
Add 1 more day (10 work days total) - Thursday 5/8
Add 1 more day (11 work days total) - Friday 5/9
KPH
Re: April Question of the Month - Join the conversation and receive a badge
My favorite piece of Decor! A quote from one of Cher's 1995 interviews where she talks about how her mom would always say "I wish you would hurry and settle down and find a rich man." She then replies, "Mom, I am a rich man!"
Interview Clip: Bing Videos
As a 24-year-old woman, it's my daily reminder that I can find everything I need within myself & everything I have, I've proudly earned on my own accord!
Almonto1
Re: Why every time I hit the create button it opens the Workspace panel?
This is annoying me more than it should! I don't need all new workspaces- I have all my sheets in folders how I need them. It needs to be an option to do a folder instead of workspace!
AZinKS
Re: Would you benefit from getting my help in person?
Dates for the next workshop should be decided soon!
In the meantime, please feel free to join our 10x Time Savers, an exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!
https://webforms.pipedrive.com/f/6ctL6D95nYL0fYjfAKvLlOjETx1bVQjHHN5WFqR76KCp5nfedBaTCAwxzAexfFPlQL
If the above link doesn't work, feel free to copy/paste it into a browser or you can use the link in my signature.
Paul Newcome
Re: Introduce yourself & get to know your peers!
Hello Everyone,
I have worked in many industries, lived in many US States, like to do many activities like flying airplanes, scuba diving, cycling, organizing (yes, that is a hobby π), entertaining guests, crafting, and dog training.
Thank you for everything you all have and will continue to teach me. I look forward to learning from you and hoping I can provide some insights as well.
Re: April Question of the Month - Join the conversation and receive a badge
My Desk brings me joy!!
I have an uplift desk with a hammock under it! I have a loupdeck, all kinds of Toys (Star wars, BTTF, Turtles, Ghostbusters etc) My desk is my happy place!!!
Joe Goetschel
Re: Dashboard Rich Text Widget Excessive Vertical Scroll Bar
I submitted a ticket and got a response
"We have identified this issue as a bug. Our engineering team is currently investigating the behavior, and we do not have an ETA on a resolution."
