Best Of
Re: Generate Document Error
Yes I have also recently seen this screen and have contacted Tech support.
I experience this issie using a Mac computer running the smartsheet app signed into the Europe region
The temp fix i found is
Sign in via a web page ie Chrome in my case.
If you get the same error try via an incognito web browser. If that works then go back to your web browser and delete cache.
I still have a case number fpr this issue that I'll follow up on again as it's gone silent on the SS Tech support side?
However based on my communication with it is a known issue with the aapp only when signed in to the Euro region.
Regards Brindles
Re: Count HAS Function Between Dates
Hi @APK Studios,
Give this a try.
=COUNTIFS({Date}, >=DATE(2024, 7, 1), {Date}, <=DATE(2025, 6, 30), {Fund}, HAS(@cell, "XXX"))
Hope this helps,
Dave
DKazatsky2
Introducing the Smartsheet Unlocked podcast...
Hi all - at Prodactive we're all about showcasing what people can achieve with Smartsheet and have been sharing tips and tricks on our YouTube channel since 2021. As we get to meet and work with some fantastic people, we thought it about time to bring some of these people in to share their stories in the form of a podcast called Smartsheet Unlocked...
We're 2 episodes in, having kicked off the series with Smartsheet Overachiever @Will Jeffords followed by Christian Armstrong, COO of Elysian Residences and the person who introduced me to Smartsheet. The full episodes (25-30 mins) are on YouTube and on Spotify, and we've also got trailer versions of around 3 mins on YouTube as well.
We've lining up a fantastic range of guests bringing you insights and real-life examples from Smartsheet everyday users, Overachievers, the team developing Smartsheet and other great contacts from within Smartsheet.
Clearly there will be some fantastic future guests here in the community that have great stories and insights to share (we already have a few lined up 😉). If you have any suggestions or feedback on the podcast, please let us know via our feedback form!
Thanks!
Rich
Rich Coles
Re: Workflow - SAME SHEET copy a cell to another column
Here’s a clunky workaround for you:
Set up a workflow to copy that row from Sheet A to a helper Sheet B.
Use a cross-sheet formula in Sheet A to pull back into a [show-me-the-history] column the target cell value that’s now frozen into Sheet B.
Cleversheet
Re: Index Collect with a Date Range
Sorry that your team is hip faking the system. I think this formula will do the trick. I'll let you advance it for your 5 checkin's.
Hudson
=INDEX(COLLECT({Check_In|Completed}, {Check_In|Employee}, @cell = [Primary Column]@row, {Check_In|Completed}, @cell >= [Hire Date]@row, {Check_In|Completed}, @cell <= [Week 1 Due]@row), 1)
Re: Multiple IF Statements Using "ISDATE"
Try this: =IF([Status]# = "Development", IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail")))
I do not see why that wouldn't work, just had to move the ). Note that this will not do anything if the Status is not "Development", and then if Closed Date is not a date, again it will do nothing. If you are looking for it to "Fail" in those scenarios it is easy to add.
The alternative way:
=IF(AND(ISDATE([Closed Date]1), [Status]# = "Development", [Delivery Date]1 > [Closed Date]1), "Complete, "Fail") should work (I did not test any of it). Hope this helps.
Meet Aravind Gnanapandithan, our May Member Spotlight! 🎉
Please put your hands together for this month’s Community Member Spotlight @AravindGP! So how did it all begin? What brought this Sydney-based Community Champion to Smartsheet? Scroll down to hear his story.
Aravind is a Delivery Manager - Smartsheet at Atturra, a Smartsheet partner. While working at a previous company, a few of his clients recommended that they look into the partner program. As he tells it, from the moment he followed their advice and explored the platform, he was hooked!
“Despite not having a technical background—and after nearly a decade of selling custom software solutions in Singapore—Smartsheet was a game-changer. For the first time, I could build solutions for clients without relying on a developer. It was both empowering and exciting. Smartsheet struck the perfect balance: Intuitive to use yet incredibly powerful.”
Over the past six years, Aravind has worked with Smartsheet both as an end user and as an implementation specialist across a wide range of use cases—and has enjoyed every step. Currently, his favorite product feature is formulas because of the power they have in transforming data into actionable insights - especially when feeding into dashboards.
“I’ve worked with formulas so extensively over the years that my team started calling me ‘The Formulator,’” he says. “It’s become one of the areas I’m most confident in. I’ve found the more skilled you become with something, the more rewarding and fun it gets.”
As Community Champion, Aravind says the Community has taught him just how deep and versatile the platform really is. He describes Smartsheet as an ocean - one where he’s only scratched the surface.
“The Community has become my go-to space whenever I have downtime at work. I often browse the Unanswered section and try to help others by recreating their scenarios and finding solutions. This habit has exposed me to use cases I wouldn’t have encountered otherwise, and it's pushed me to think creatively and explore new ways to solve problems.”
In the future, Aravind hopes to contribute to the Community platform and the community at large more strategically. He was recently invited to join the Smartsheet Partner Product Advisory Council, and is excited about the opportunity to help shape the product roadmap. “I’m passionate about making the platform even more accessible and impactful for users, and I hope to use this role to advocate for features and improvements that drive broader adoption and deliver real value across different industries,” he says.
When he’s not being The Formulator, there are three major things he loves to do:
- Driving and taking long road trips - in just a few years, he’s driven through five of the seven states in Australia
- Mobile gaming
- Spending time with his daughter, whether it’s reading her stories or joining in on one of her many imaginative games
Thank you Aravind for all that you do!
👉🏻 Do you know someone in the Community who should be next month's Member Spotlight? Nominate them here (NOTE: Any Community member can nominate someone else in the Community).
Alison C.
Re: Dynamic View $ Formatting
Hi @Kim Stephens,
Having tested this again today, it looks like the issue has been resolved - is this working for you now?
Thanks,
Georgie
Georgie
Re: Report showing activity per month grouped by resource
I think I actually just figured it out, at least for us. I set up a filter to show rows that match all conditions, then set the Start Date to "is less than or equal to" the last date of the month I want and set the End Date to "is greater than or equal to" the first date of the month I want. For example, if I want all rows with activity in May, my filter is set with Start Date is less than or equal to 5/31/25 and End Date is greater than or equal to 5/1/25. It gave me all the rows with activity in May. I tested it a few times for a few different months and it appears to work. Hope it works for you, too.





