Best Of
Re: Function for "current user" to use in formula?
Using a helper column, such as Breadcrumbs, is a standard practice in this case.
=JOIN(ANCESTORS([Task Name]@row), "> ")
Then, use the column in the report.
Re: Calling all Music Fans - Let's make a playlist for ENGAGE 🎧️✨
I have a few GREAT songs!
1. Delta Sleep from Brighton, England. They write songs that have real meaning and are just SO good!
- Delta Sleep - Sunchaser - https://www.youtube.com/watch?v=8IaESL2GMQM
- Delta Sleep - Slow Burn - https://www.youtube.com/watch?v=c3Z5s2iZgAQ
2. Enemies from Irland! They guys we have had on the playlist in the past for engage. If you don't know them they are amazing and great happy music!
- Enemies - Love Unlimited - https://www.youtube.com/watch?v=xFYBar5gCRY
- Enemies - Play Fire - https://www.youtube.com/watch?v=d6PoF97A_FA
3. Strawberry Girls - Salinas, CA Again another great band!
- STRAWBERRY GIRLS - Tasmanian Glow - https://youtu.be/vSbk8iYP_zo?si=RwDXRcUz9jNSM-8v
- Strawberry Girls - Mini Ripper - https://www.youtube.com/watch?v=mHy6F3wwZUU
Joe Goetschel
Re: Send Dashboard via email - manually and automated workflow
Hi @MHalvey55,
Thanks for the interest on this thread. I can assure you Smartsheet is indeed working on this capability, I had another working session with them a couple of weeks ago. As with all new features, there is no published timeline for it but it is being actively worked. It seems like such a simple request, but as we delved deeper into needs and use cases, this becomes quite a complex challenge. I do think Barak and his Team are going in the right direction and the solution will be a great one. I would suggest you keep monitoring this thread, I know Barak follows it as well so rest assured the right person will see your post.
If you have not voted up this idea at the top of the thread, please pile on. The more support we have the better. Have a great day!
TomG
Re: Welcome to the Education Community!
Hello Everyone,
- Where do you work and what’s your department/role? - North Central College in IL. Director of Technology Infrastructure.
- How long have you been using Smartsheet? - 5 years
- How are you using Smartsheet today or planning to in the future? - Project Management Office which runs all the projects for our division (currently 21). Cybersecurity Controls, Request Management, Policy Governance, A/V Inventory, Infrastructure Responsibilities, Project Cost Tracking & License Management.
- What else would you like to learn from your peers in the education industry? - How's the acceptance for Smartsheet going at your school?
Scalperjim
Re: Welcome to the Government Community!
Where do you work and what’s your department/role?How long have you been using Smartsheet or Smartsheet Gov?How are you using Smartsheet or Smartsheet Gov today or planning to in the future?What else would you like to learn from your peers in government?
Hi! I'm Trang. I am an Analyst and PM for a well known IT consulting firm. I have been using Smartsheet for about 9 years. My previous job I was a dedicated Smartsheet consultant architecting and building solutions across one of the largest health plans in the US. With my prior Smartsheet experience, I was also asked to take on the role as the Smartsheet product owner for the entire firm when I was hired in my current position, which I gladly accepted and get the opportunity to spread the knowledge and benefits of the product.
Although we do not have or on a Smartsheet Gov plan, 95% of our contracts are national, state or local government so are bound to the same data security, confidentiality and compliance requirements and standards. The firm uses Smartsheet for traditional project management, but have heard of other types of solutions. I am in the process of creating Smartsheet solutions for Operational Risk Management and PPM.
I would love to learn the end to end governance process people use to best manage data security - from identification, auditing, guardrails or exceptions integrated and why. I'd also love to learn how data security updates are best integrated into the tool as they are released and what types of automations people have set up to help manage the constant data security updates.
Re: Welcome to the Government Community!
Hi all. I'm Jenni and I live and work in Melbourne, Australia.
Working in the Not For Profit sector at a Primary Health Network with a workforce of just over 100 people. We receive federal government health-allocated funds and commission local services to deliver primary health services.
I joined the organisation 15 months ago as a Project Officer and had never even heard of Smartsheet. Now I'm one of the leading users and provide support and training for others!
Whilst we are technically not government, we are bound by government data security and compliance requirements so this is a big focus on how we use Smartsheet.
Smartsheet has mostly been used as the official project management tool for strategic projects - for their management and also reporting to the Executive and the Board. Dashboards are my world 😍 but as all our reports need to be included in a Word document 🙄 we 'MacGyver' a lot!
Other things we've created:
A tool kit for tracking overtime to be taken as Time in Lieu of being paid overtime rates (this might be just an Australian thing?). It is a thing of beauty, if I do say so myself.
Business planning mechanism including tracking against KPIs.
A connector (using forms and workflows for notifications) between a mental health referral intake team and the team who manage the services, to flag changes in services or problems encountered by clients.
I've been grateful to connect with @Mark Weeks who also works in govt in Australia to learn about getting the most out of Smartsheet whilst complying with data security and compliance.
I created these coffee mugs for the team I work in for Christmas presents 😁 My best days at work are creating things in Smartsheet!
Jenni
Re: May Question of the Month - Join the conversation and receive a badge
"I’m like the Fairy Godmother of my university!" ✨
You know how Disneyland runs smoothly with rides, parades, snacks, and characters all working together? Behind the scenes, someone has to keep track of everything to make the magic happen.
At my job, I do something like that—but at a university!
I help people see what’s going on by organizing big piles of information and turning them into easy-to-understand charts and pictures—like a map of what’s working and what needs help. I use a special tool called Smartsheet—it’s kind of like my magic wand.
If someone wants to how a project is going, I can show them instantly.
And just like Fairy Godmother teaches Cinderella, I teach other people how to use Smartsheet so they can create their own magic too.
I also help with planning and organizing—like a behind-the-scenes helper making sure everything runs like a well-oiled parade float.
Deena Duran
Re: May Question of the Month - Join the conversation and receive a badge
I bang bang on the keyboard and cool stuff comes out.
NeilKY
[Control Center] How to rename Intake Sheet? Admin workspace?
Hey there, we're trying to rename our Intake Sheet & wondering what the best way to do this is / anything to watch out for. We would also like to rename our Admin Workspace. Looking for advice before we go messing with anything. Let me know if you need any additional details & thank you in advance!!
EDIT: So I went ahead & renamed the Intake Sheet & when I went back to Control Center it was still connected & had all my settings as-is—honestly I'm really impressed with how well it went!! I'm saving the blueprint without changes out of paranoia alone, it didn't seem like there was anything to update at all! Next I'll try the workspace.
ro.fei
Re: Welcome to the Project Management Office (PMO) Community!
Hello!
I've been using Smartsheet for 4 years now.
My primary role is to create Smartsheet solutions for Project, Program, and Portfolio Management. I support multiple PMOs.
I also develop trackers for our finance team to support forecasting expenses such as hiring needs throughout the current year and into the upcoming year.
I build intake, change management, new business opportunity pipeline and roadmap, and several other operations solutions.
There's no telling where my Smartsheet development will take me or what type of solution I'll be tasked with next.
I like learning new ideas and approaches from my peers. I love learning about formulas I haven't used before, or using formulas I've already used but in new ways.
I'm looking forward to what this PMO Community will come to offer and include.
Best to all,
-Ray
Ray Lindstrom