Best Of
Re: Show Off your Smartpets
I am going to break my animals into two segments - First up the adorable dogs. Teyla is an 11 year old Corgi mix (Labrador & Border Collie) and Harley is a 1 year old Corgi.
Re: Taking the gloves off - Smartsheet customer service sucks especially with USM
@Monica Yes, it's a challenge when you've built out a solution and now the rules are changing. In the immediate term we can probably help negotiate some at renewal time to lesson the impact.
Otherwise, there are some other ways using some additional tools that you could keep your solution intact, but reduce the need for licensing all users.
Let me know if you needed any input on that.
Darren Mullen
Re: Deleting a User from multiple sheets
This issue has been flagged as a huge security risk and our company is looking at canceling our subscription because of it. Is there any plan to better secure the system?
Jerry Wilson
Re: DataMesh Note Section
I like the idea of having a note or description field in DataMesh too. When you’re managing dozens of configs across different workspaces, it can get hard to remember which one is tied to what purpose. A simple description box (even with a character limit) would help a lot with organization and reduce the need to rely on naming conventions alone.
Until Smartsheet adds something like this, one workaround could be keeping a separate “Config Tracker” sheet where you log each DataMesh setup, its workspace, and its purpose. It’s not as seamless as having notes directly in DataMesh, but it gives you more flexibility in how much detail you store.
Hope it answered your question. 😊
Liam Dawson
Re: When will resources for self-studies be available (and other questions)? (Pro Learning path)
Thanks for the reply Matt!
I'm still hoping for some sort of timeframe through an offical update as it would help my planning a lot moving forward but it's nice you took the time to welcome me to the forum (I'm very new here!) and noticed my post and concerns. I'll definatly bookmark this and pop in in the coming days to see development.
Regards.
When will resources for self-studies be available (and other questions)? (Pro Learning path)
Hi!
I'm working to expand my knowledge in Smartsheet and I feel I've been stuck in limbo with the current changes and still waiting for updates. I have core and project management certs and was on my way to take the Sys Admin when it (imo rather abruptly) product cert when it got removed.
I work mainly through self studies.
1. Smartsheet professional
Basic Principles of Project & Change Management (self-paced content to introduce concepts) is said to be "Coming soon"; when?
https://smartu.smartsheet.com/page/learning-plan
2. "All the skills required to be a Smartsheet Certified Professional are taught in the Builder Path and Professional Learning Path (coming soon)" ; when?https://smartu.smartsheet.com/page/certified-professional
3. Is there any deeper definition of what's on the exam?
The defintion I can find is here:
https://smartu.smartsheet.com/smartsheet-certified-professional-public
But this is vastly less detailed then say Core and Project Management definitions. What I'm looking for is something I can use as a blueprint and understanding similar to
https://smartu.smartsheet.com/page/project-management-certification-resources
I could use the above to actually work deeper in self-studies with.
Is there none?
4. Just to be certain here.
"PREREQUISITE: You must receive the Builder Certificate of Achievement to attempt the Professional certification."
If I have the Core certification I can still sign up and do the exam/cert attempt right as they are correspondent to eachother?
https://smartu.smartsheet.com/smartsheet-certified-professional-public
Thanks for the answers. Sorry if this is posted in the wrong forum; I'm rather new here.
Re: When will resources for self-studies be available (and other questions)? (Pro Learning path)
Keeping up with all the certifications can be challenging. To be honest though, I've gained the most knowledge from right here in the Community Forums. Sometimes I'll read someone's issue and work through how I would solve it. If I'm not too sure that's the best way then I bookmark the post and wait for someone else to reply and see how their response compares to how I would've solved it. You can learn so much about how the tool functions in real world environments here in the Forums.
I know its not the answer you were looking for, but I hope it helps in some way.
Matt
Matt Johnson
Re: Changing Seat Type to Guest
FYI here is our business case submitted to Product Ideas. @Estelle Redding
tim.wimmer49936
Re: INDEX/MATCH Most Recent Entry
If the new entries are by form, you could also set the form to put new entries at the top of the sheet and use the standard INDEX/MATCH.
Another option if you have multiple rows for the same project with the same date / time stamp (and new rows at the bottom) would be to use the INDEX/COLLECT to collect all rows for the Project Name, then a COUNTIFS for the "row number" portion of the INDEX.
=INDEX(COLLECT({Percentage Complete}, {Project Name}, @cell = [Project Name]@row), COUNTIFS({Project Name}, @cell = [Project Name]@row))
Paul Newcome
Re: INDEX/MATCH Most Recent Entry
Hi @John Loushin,
See if this works for you.
=INDEX(COLLECT({PERCENTAGE COMPLETE}, {PROJECT NAME}, [Project Name]@row , {CREATED}, MAX(COLLECT({CREATED}, {PROJECT NAME}, [Project Name]@row ))), 1)
Hope this helps,
Dave
DKazatsky2