Best Of
Re: Auto-Populate Hours Column
You'd be better off putting this result in a Helper column(s) to capture the updates and then using a SUMIFS or COUNTIFS formula to add it all up as you your checkpoints in your hours column. You can't both have a formula and manually add to it, but that's where having results hiding in Helpers can do that for you.
Nic Larsen
Re: June Question of the Month - Join the conversation and receive a badge
I hate to say it, but it's two Smartsheet communities that immediately come to mind! (Trust me, I have PLENTY more I'm part of!)😍
The first was our internal Cisco Smartsheet Community, led by our Customer Success person. It was magical - we solved each other's technical challenges while sharing snippets of our lives too. I still remember setting a special "ding" for the group notifications and eagerly checking whenever it went off!
My current favorite is much smaller - the peer chat I have with @Protonsponge Having that one person who truly gets both your professional challenges and personal journey is incredibly powerful. We bounce complex Smasrtsheet integrations off each other, vacation plans, home remodels, and food suggestions!
What makes both special? That authentic blend of professional expertise and genuine human warmth. The best communities aren't just about solving problems - they're about feeling genuinely connected to the people behind the questions and solutions.
Re: RESOLVED Lost Permission to My Own SmartSheet!
Thanks yes! We recently changed email addresses with a branding change and that was it! Crisis averted!
PMQueen
Re: Auto-Populate Hours Column
At the basic level, you'd just need. This just looks at the cell and if it's not blank, it'll add a 1 to the cell this formula is in.
=IF(NOT(ISBLANK([Assigned To]@row)), 1)
Nic Larsen
Re: June Question of the Month - Join the conversation and receive a badge
What is the best example of a community you have seen?
Other than my job's Teams Communities for various things like Tech, Smartsheet, Developers, Volunteers, Women's Groups, etc.? This Smartsheet Community is the best I have ever seen. It is definitely organized, easy to navigate, and everyone here is so friendly and accommodating.
Angie Bryant
Re: June Question of the Month - Join the conversation and receive a badge
This is the first and only technology community I actively participate in. I love how active it is and how is it is to jump right in and start contributing!
NRJW53
Re: June Question of the Month - Join the conversation and receive a badge
Definitely the Smartsheet community, but I would also say the Vyond community has been really helpful.
apopken
Re: June Question of the Month - Join the conversation and receive a badge
As a former educator of over 17 years, I must say the best communities for me were in schools and the giant community of support surrounding a school. From the students, to all the teachers, administration, support staff and the people in the school's community - it was always a special thing. Each year was different and it was always exciting in August to kick things off with this huge team, all with the same goal of empowering our students to achieve great things. A special time in my life, and all former or current educators know what it's about.
Ryan.Ray
Re: LEN ... FIND ...
I got an error with that formula but you got me close enough that I was able to work it out the rest of the way. New formula I used:
=LEFT(SUBSTITUTE([Presenter Link]@row, "https://zoom.us/s/", ""), 11)
Thanks!!
Jennifer Kaupke
Manage seat types more effectively at scale!
To provide you with greater control over your Smartsheet subscription, we have implemented the following updates:
- Modified Provisional Member counts: Now, Provisional Members are considered anyone who’s commented, edited, or created in the last 90 days versus just being shared to assets with Commenter or Editor access. Learn more.
- Quick filter to see who’s converting to paid: The new Billing column and filter show who’s converting to a paid Member this cycle, so you can quickly identify which users to review. Learn more.
- Faster seat management: We increased bulk seat downgrades from 20 to 200 users at a time to allow for scaled, systematic management. Learn more.
Environments availability: Commercial US, Commercial EU
Plan availability: Pro, Business, Enterprise
Subscription Model Availability: User Subscription Model
Stay informed by Subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Ryan Dougal