Best Of
Re: July Question of the Month - Join the conversation and receive a badge
One of my ongoing goals is to complete my PMP. I've been having a hard time finding time to lock in and study.
Isis T
Re: Queries about new payment methods
@Naeem Ejaz we wouldn't be able to do it with our AD integration. I was just asking the general question and to point out yet another "flaw" to the USM.
Re: Looking to summarize data from multiple rows to multiple columns so I can generate a document.
How about something like this:
Step 1
Use a JOIN function to get all of the data you need per infraction into one cell, something like:
=JOIN(Date@row:[6 Month drop off date]@row, " | ")
This can be one hidden column in your existing sheet.
Step 2
Transpose each row into a column.
Use an INDEX function to return the value from the new column from row 1 in column 1, row 2 in column 2, row 3 in column 3….
=INDEX(Combo:Combo, 1)
=INDEX(Combo:Combo, 2)
=INDEX(Combo:Combo, 3)
You would do this in your new summary sheet and replace the column name with a cross sheet reference, so the formula would look more like this (depending on the name you use for your cross sheet reference).
=INDEX({Combo}, 1)
=INDEX({Combo}, 2)
=INDEX({Combo}, 3)
The summary sheet would look like this:
Would that do the trick? Or do we also need to look at the employee name?
If so, you can add the name to the first list:
And to the second summary. Then include a COLLECT function in the INDEX to include only the rows where the names match. (The IFERROR is there to return nothing if there is no match, rather than an error message).
=IFERROR(INDEX(COLLECT(Combo:Combo, [Employee Full Name]:[Employee Full Name], Name@row), 1), "")
Change the 1 to a 2, 3, 4 etc. for each column. The summary table would look like this:
Hope that helps.
KPH
Re: Importing Data into existing sheet
@Tommi @Danielle Wilson @AnneSh We have a new option available now using a handy browser extension to solve this problem if you don't have access to DataShuttle or want to do an import without needing to create a DataShuttle configuration:
Darren Mullen
Re: UserName and Smartsheet Community Profile Page Link
Hi,
I hope you're well and safe!
This is the link you can share.
https://community.smartsheet.com/profile/virgh
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏
Andrée Starå
Re: July Question of the Month - Join the conversation and receive a badge
What is a personal goal you've set for yourself this year, and how is it going?
This is a great question! One of my personal goals that I have set for myself this year is to begin documenting and recording everything about my role, duties, responsibilities, and position within our district. I am nearing my 40th year working for our local school district, and as I look forward to my eventual retirement, I was asked to not only begin documenting everything I do, but to begin recording all of the background knowledge that is contained within my brain and to begin to think toward how to transition someone new into my role while also passing along all of my historical knowledge. I am learning that this is a very daunting task, but so far, with the help of our Smartsheet tool, it is beginning to take shape. Being able to use Smartsheet to help me document all of my roles and responsibilities is essential, especially since my role was created as a new role in our district, all thanks to Smartsheet! In fact, I am also very excited that our district is truly embracing the Smartsheet tool, and our continued commitment to growing capacity within our district for using Smartsheet is also part of why my role exists. In fact, part of our commitment to growing capacity has led to our district allowing more than just me to attend Smartsheet ENGAGE! This year, I will be bringing 7 additional team members along with me in November. I am so excited for them.
Work with Flow - A Space Story
Hi Community,
The previous edition of our Work With Flow series was packed with smiles all around — it was truly inspiring to see how you’re using Smartsheet to bring joy to your workplace! Now get ready, because we've got another great story coming your way.
When individuals or teams Work With Flow, they work in a way that is efficient, intuitive and empowering. Rather than getting bogged down by complexities, they find rhythm. Being a Smartsheet customer means powering your flow with a simple, flexible platform, where even complex, high-stakes projects become clear, manageable, and surprisingly simple.
At the crossroads of vision and precision, a leading space agency transforms ambition into reality. Driven by the power of Smartsheet, by coordinating teams and tracking vital components, AI enabled workflows help every mission stay on course. Obstacles become streamlined pathways, empowering these pioneers to turn missions into milestones.
Now let's turn it back to you! In the comments below, share how Smartsheet helped you turn an ambitious vision into a reality, and you’ll earn the Work With Flow badge for your profile.
Rebeca S.
Re: SmartU New Offerings - Smartsheet Builder Path & more!
This just made my day! I've been looking for something like this for awhile now.🤩
Isis Taylor
SmartU New Offerings - Smartsheet Builder Path & more!
Hello Community,
Looking to build and showcase your Smartsheet skills? We’ve got exciting updates directly from Smartsheet University. Read on to learn about their enhanced training and certifications that’ll set you apart from the crowd!
Live now! - Smartsheet Builder Path
This instructor-led path is specifically crafted to provide you with the essential, hands-on knowledge you need to confidently begin building and organizing your work within Smartsheet. Whether you're just starting out or want to reinforce your core understanding, the Builder Path is your go-to resource.
Coming soon - NEW Certifications
- Smartsheet Certified Professional - Identify ways to improve efficiency and collaboration in your organization. Build Smartsheet solutions to meet business needs and quantify the value of your work.
- Smartsheet Certified Architect - Establish yourself as an industry thought leader who builds, implements, and manages complex, scalable Smartsheet solutions.
Good news! The details for earning your Smartsheet Professional Certification are ready now! Discover what it takes to achieve this credential and set yourself apart.
Ready to unlock the next steps?
Access all of these offerings and more with Smartsheet’s new Learning and Certification Pass! This pass includes access to all instructor-led courses, self-paced eLearning courses, and two attempts at each certification.
We can't wait to see how these new offerings help you elevate your Smartsheet expertise and achieve your goals!
Rebeca S.
Re: How do you avoid Power BI Semantic Model Error when column headers are modified (add/remove/edit)
Hey! Thanks for the recommendations.
There are other people responsible for the sheets and I cannot control them whether they need to edit stuff. Im just glad I get notifications for errors.
I've been checking BI forums for issues similar to this, but I thought of asking it here being the semantic model source if Smartsheet.
Im still open to hear other Smartsheet users workaround other than the normal process.
heyjay