Best Of
Re: I have earned the Smartsheet Automagician Badge but I am not able to claim it
Hi @Shweta Sharma,
I had the same issue recently with another badge and I used the support ticketing system and had the badge applied within 48 hours. You can use the link below to get to the right place.
https://supportportal.smartsheet.com/s/
John
John_Foster
Re: Trouble with Checkboxes
Hi @Kayla Q
I hope you're well and safe!
The pro plan only allows editors if they are on the same plan/account.
More info.
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Re: Download activity log - empty folder
Hi Travis! Yes, the problem with my sheet was that the name had a pipe (|). This is an extract of the feedback I got from the Smartsheet team:
"(...) there's an existing bug where downloading Activity Log from a Sheet or Dashboard with a pipe ( | ) OR asterisk ( * ) in its name, it results in a blank .zip file. (...) As a workaround, our engineers recommend to simply removing the pipe/vertical bar from the sheet title."
They said they will be working on a solution, but in the meantime, I removed the pipe from my sheet's name and the problem was solved.
Hopefully, your situation is similar to mine and this solution helps you too. If not, I would suggest contacting the Smartsheet support team https://help.smartsheet.com/contact.
Good luck!
Julieta Alvarez
Re: Count # of Parent Rows in a Sheet
The workaround I have used is to create a helper column to count ancestors. You could also choose to count descendants instead.
=count(ancestors([Employee Name]@row)
Make it column formula. Then in your sheet summary:
=countif([Ancestors]:[Ancestors], = 0)
Hope this helps
Andy S.
Re: Formula to Capture Current Task Start Date and Next Task
[Current Task Start Date] should be doable with a standard INDEX/MATCH when matching on the Current Task.
[Next Task.] would require a helper checkbox column with the following column formula:
=IF(COUNT(CHILDREN([Task Name]@row)) = 0, 1)
Then in the [Next Task.] field you could use something along the lines of
=INDEX(COLLECT([Task Name]:[Task Name], Helper:Helper, @cell = 1, Status:Status, @cell <> "Complete"), 2)
Paul Newcome
Re: Trouble with Checkboxes
@KPH I think I figured it out. The user who shared the sheet with me has a pro account. I'm not sure why I can't edit it because I have an enterprise account. I think the user sharing the sheet needs to update to a business plan
Kayla Q
Re: formula works fine in individual cells but can't be converted into a column formula
Hi @OshaK
I hope you're well and safe!
To add to Carson's excellent advice/answer.
As a workaround, you can also use the INDEX function to reference a specific row and still be able to convert it to a column formula.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Re: IF formula to calculate points
Hi @Sam C
I hope you're well and safe!
Try something like this.
=IF(Occurrence@row = "Tardy", 1, IF(Occurrence@row = "Late", 2, IF(Occurrence@row = "Half", 3, IF(Occurrence@row = "Full", 5,0)
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Connect and hear from past ENGAGE attendees 👋
Hello Community,
It was back in September at ENGAGE in Seattle that we announced ENGAGE will be coming to London May 14-15, 2024!
If you’ve been to ENGAGE previously, help our first-timers prepare for the upcoming ENGAGE in London by sharing your experience. [Earlier this year, many of you shared what you were looking forward to most at ENGAGE and we loved reading your responses.]
What would you say to someone who's considering attending ENGAGE for the first time?
If you’re going to be experiencing ENGAGE for the first time – connect with other attendees in the comments below, learn about the experience peers have had in the past, and get helpful advice.
ENGAGE in London will be an immersive experience packed with actionable sessions (presented entirely in English), real-time solutioning, thought-provoking speakers, and the tools to help you realise new potential.
Different from ENGAGE in Seattle, our London event will be much more intimate and ideal for connecting with like-minded people.
Be sure to check back regularly for updates. Event registration opens in February.
Hope to see you there.
Arsineh
Re: Connect and hear from past ENGAGE attendees 👋
What would you say to someone who's considering attending ENGAGE for the first time?
- Don't even hesitate, just GO! You won't regret it (except perhaps if you think back on previous ENGAGE years when you did not or were unable to attend).
- Bring your laptop as you will learn sooooo many new tips and tricks that you will want to nerd out back in your hotel room each night implementing everything you learned and updating your existing solutions.
- Drink lots of water as your mouth may go dry from talking and engaging with everyone. The networking is truly one of the most powerful and valuable reasons to attend ENGAGE!
- Explore all of the booths and be sure you have brought with you a bigger suitcase to store all of the goodies you will pick up along the way.
- Prepare to be energized by everyone around you, being with like-minded thinkers and fellow Smartsheet lovers will get you hooked and then you will never want to miss out on another ENGAGE, ever!
- Plan on attending the gatherings and parties - they are amazing!
- Enjoy, enjoy, enjoy --- ENGAGE is one of the best experiences!!!!
