Best Of
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
Re: Changing Seat Type to Guest
FYI here is our business case submitted to Product Ideas. @Estelle Redding
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
Re: Changing Seat Type to Guest
Correct. We have been on it since 2018 and now we are actively working to transfer processes to other systems. The one and only chance that we would continue is if they give back control of user creation and asset creation to Admins. The provisional user model is ridiculous. Even if we did renew next time, it would be a much smaller footprint as we are actively moving things out. There are certain departments in the company that would never use it again.
Re: Dynamic dropdowns - Waterfall request
This would be huge for us. We would also like to be able to populate dropdowns via reference sheets so we don't have to edit them every time a job title is added or a department head changes.
Sara Campbell
Re: Dynamic dropdowns - Waterfall request
It would be great if we could setup the ability for conditional dropdown lists / feilds directly in smartsheet without workarounds in forms/etc.
Re: Dynamic dropdowns - Waterfall request
Make a conditional dropdown list that dynamically responded to values of other cells
