Best Of
Re: Failed to share operating workspace with PMO
Not a group.
Our account admin was not shared to the Parent Workspace and the blueprint lists the them as owner.
I shared it and it looks like it's all working now, so I am thinking that's what caused the error.
Thanks for your reply!
Marisha90
Re: Updating one sheet from another
Hi,
I hope you're well and safe!
To add to Tomasz's excellent advice/answer.
If you don't have access to the Table View, you can use a combination of INDEX/MATCH instead.
In any case, you can use the VIN to connect them.
More info.
Here's the structure for an INDEX/MATCH combination.
=INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row,{ColumnWithTheValueToMatchAgainsTheCell}, 0)
To connect them row by row, you could use an Autonumber Column in the Source sheet and add a so-called helper column to manually add the row ID on as many rows as you need in the Destination sheet.
Update because I reread the post and noticed that I missed what Paul mentioned. I agree with him, use MAX COLLECT instead.
Would that work/help?
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: Using Bridge and Conditional Junction to evaluate if a Checkbox is Checked
That's the ticket. I knew it was something simple, and I appreciate the help.
Frank S.
Re: Community Recommendations - Let's share our favorites!
LOL @joelsmit94161 - my son’s obsessed with asking ChatGPT 'who would win' matchups. The answers are always hilarious and weirdly deep. It's like snack-sized philosophy with superheroes!
mcullen
Re: May Question of the Month - Join the conversation and receive a badge
This is the funniest feed. I would explain this the same to a 5 year old as to an adult. I make people smile and keep them present. I work with people making their lives a little nicer and easier every day. Be Kind, share a smile. We don't have enough of it in our world.
AMPM_4ME
Re: Community Recommendations - Let's share our favorites!
I have to agree with Michelle on ChatGPT. As I was packing up to move to my new office, I thought "Who would win in a battle of US presidents(in their prime) with no weapons." Once I was done packing I looked back at ChatGPT and read the results of my question while I ate lunch. It was quite entertaining.
joelsmit94161
Re: Extract the text word from a date column
Hi @Michael Albano,
@AdamSYNH's answer is excellent!
I'd also recommend using a different AI service for Smartsheet formulas in the future. I use ChatGPT's 4o model and get pretty good results compared to Smartsheet's AI. The downside is that you have to tell ChatGPT more about your sheet, since it doesn't have direct context from your sheet.
Best!
SSFeatures
Re: 📚 New Onboarding Resource: The Smartsheet Essentials Glossary
Love this! It's very intuitive and easy for onboarding new team members!
Stacy M
Re: 📚 New Onboarding Resource: The Smartsheet Essentials Glossary
Love this! Thank you!
Peggy Parchert
Re: 📚 New Onboarding Resource: The Smartsheet Essentials Glossary
Looking forward to sharing this with our new users! Thank you for this, and the wealth of information available on the platform. This is a great one page summary, it also acts as a kind of launchpad to more information too.
AdamSYNH