Best Of
Re: TODAY() not updating till the file is opened
@Jake Gustafson I personally use the Record a Date method so I only have to set up one automation, although that does count towards cell limits in larger sheets.
Paul Newcome
Re: Exporting Report's with Grouping
I have been losing my MIND not being able to export in a grouped format. Until now. THANK YOU FOR THIS! Gold Star! ⭐️
Paula Grahame
Re: Smartsheet Intelligent Work Management and McLaren Formula 1
My largest Smartsheet build to date, has been the development of a Life Cycle Management solution, integrating contributions from our Cross-Functional Project Teams, Regulatory Department, and Supply Chain Organisation. This initiative provides outputs that empower our product teams to better anticipate impacts on the supply of our pharmaceutical products due to regulatory filing and approval updates.
The solution leverages a PMO reporting structure, Data Shuttle, Data Mesh, and the Control Centre to consolidate outputs from various functions into data-rich, meaningful dashboards. Working with Flow allows us to connect contributions from numerous functions effectively, while also harnessing system data to ensure our product teams are well-positioned to maintain a seamless supply of our pharmaceutical products.
Protonsponge
[RECAP] Bobbie x Kim Chappell: Building a Mission-Aligned Brand
Calling all marketing enthusiasts! A brand new episode of the Brand Collective podcast is here, and I’ve got the highlights for you.
This time around, meet Kim Chappell, a driving force behind Marketing at Bobbie. Kim's journey into marketing shows how valuable diverse experiences can be. Her background in journalism made her a firm believer that everyone has a story to tell, and that belief now guides their commitment to sharing authentic stories that resonate deeply with their customers.
In this episode, Kim shared some key perspectives on:
- How Bobbie’s mission-aligned, mom-led team inspires creativity, passion, and a deep connection to both the product and the customer journey.
- How her experiences in journalism and motherhood equip her to tell the stories of feeding parents and build a brand that fosters emotional connection.
- How Bobbie’s commitment to authenticity keeps customers at the center of its campaigns and attracts partnerships with figures like Meghan Trainor and Naomi Osaka.
🎧 Join the conversation. Has anyone ever taken a bet on you? How did that impact your career?
During the conversation, Kim shared a personal story about the Bobbie co-founder who "bet" on her potential. Have you experienced a similar moment where someone's belief in you significantly impacted your career? We would love to hear about it.
Happy listening!
---
Want to check out more Podcast Recaps? Find them all here. ✨
Rebeca S.
Re: Smartsheet Intelligent Work Management and McLaren Formula 1
As a seasoned consultant, I'm electrified when our clients discover their flow with Smartsheet! The upcoming AI visualization tools that translate simple questions into powerful charts instantly reveal insights they never knew existed in their data. I'm particularly excited about the new AI-driven automations that will empower anyone to master complex workflows without technical expertise.
That moment when scattered processes transform into a harmonious symphony of collaboration? Pure magic. That's what Working With Flow means to me – watching people's faces light up when they realize they've reclaimed hours of their day for work that truly matters.
Re: Smartsheet Intelligent Work Management and McLaren Formula 1
This is an amazing story! I love Smartsheet! I was just telling someone the other day, I dont know why I drank the Smartsheet Kool-aid but I am so glad I did! This saves my clients countless hours, and even myself too!
Paul.Woodward
Re: New streamlined creation experience
Adding my down vote here as well on the "Streamlining" / Removing Sheet Folders and Moving Sheets into Folders. Major frustration of common functionality used for years. Happy to see the community here with recent info on this, I'm hopeful the smartsheet team will help us out here.
Jim K
Re: TODAY() not updating till the file is opened
Agreed that this is annoying. My workaround has been to create a Lock Rows automation to occur at 1:00 AM and an Unlock Rows automation to occur at 2:00 AM. Depending on what time zones you have people working in, that might not work as well or you may need to dial it in to some very specific row records to avoid inconveniencing anyone. For me, it wasn't as noticeable like Paul N mentioned with sheets with a high amount of activity, where new Form submissions were refreshing the data. But when just looking at Dashboards and metrics, it becomes noticeable quite quickly.
Jake Gustafson
Re: TODAY() not updating till the file is opened
@Avinash Chandra This has been the case for as long as I can remember. The sheet must be activated for the TODAY function to update. Whether this is through actually opening the sheet, update requests, form submissions, automations, or other methods, the sheet needs to be activated.
The method I use is to insert a date type column and set a Record a Date automation to run everyday at 12:00am and record the date in my date type helper column. I have never had an issue with this since I implemented it.
Paul Newcome