Best Of
Re: Get Sheet (ID) by Name using Smartsheet API
Hi @jokano1
I would use List Sheets to get a list of all the sheets I have access to (see here), which will bring back the sheet Name and ID. Then loop through to match the Name and get the Sheet ID for your next call.
Cheers,
Genevieve
Genevieve P.
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