Best Of
Re: Smartsheet recognized as a Customers' Choice in the Gartner® Peer Insights™ + Giveaway
One fun and unique way I’ve used Smartsheet was to build an employee recognition program. When someone gets recognized as a “Rock Star,” they automatically receive a personalized certificate. I also created visual dashboards as landing pages to make it easier (and more fun) for the team to navigate Smartsheet. It’s been a great way to celebrate wins and keep things user-friendly at the same time.
mcullen
Re: July Question of the Month - Join the conversation and receive a badge
One of my goals this year was to roll out a scalable Smartsheet solution for use within my organization. Earlier this month I was able to fully implement the solution in a real world context. It's a great feeling when you can see a project come together and take on a life of its own!
Andy_B
Re: IFERROR Formula Not Working
The error is caused by the COUNT being 0 and there is no row 0 so the INDEX can't return a value. You could add an IF to the start to check the COUNT is greater than 0. Something like this:
=IF(COUNT(CHILDREN()) > 0, INDEX(CHILDREN(), COUNT(CHILDREN())), "0")
KPH
Re: July Question of the Month - Join the conversation and receive a badge
My goal this year was to complete my MBA, and I just graduated on 7/2/25! I am very proud of my accomplishment.
Amanda Winter
Re: Introduce yourself & get to know your peers!
Howdy.
I'm Chuck, and I'm a Smartsheet-designer-to-be. I was an Access developer back in the 90s and 00s (and other databases before that). I've been doing Business Analysis and app design and process redesign and change management, and whatever else was needed, my whole career. For the last nn years, I've been concentrating mostly on Excel/VBA automation, Power BI, and product management for Shell and now for NASA. Last week, I became a lurker on Smartsheet forums so I can discover how you all are using it, what it's great at, what problems to solve with it, … maybe learn how to be a developer with it.
CLH
Re: Deactivate form after set # of entries/submissions OR by date
I think it would be a great idea or a great option to have the ability to place automation on the form Activation/Deactivation button.
In my line of business we are constantly activating and deactivating multiple forms every week for a specific number of days. Having so many opening and closing forms becomes a little overwhelming when trying to have a cut off date and time. The option to set this up when opening the form that it should closed on this day at this time would be a HUGE help!
Reginald
Re: July Question of the Month - Join the conversation and receive a badge
I have a goal to go on fifty nature walks where I am totally present in the moment; no answering emails, no listening to podcasts, no reading a book. So far I've done 10 so I have some catching up to do.
JessiG
Re: Mouse-over / Alt-text to Dashboard Widgets
If I may add another example, I'm using "Latest Comment" in my sheet and pulled the comment for one row into a report. Then I have that report on a dashboard. In the dashboard, I really need the just part of the comment to show then if someone hovers over that comment it should display the full comment, as shown.
Kathy PPT
Re: Mouse-over / Alt-text to Dashboard Widgets
Idea: enable "mouse over" functionality on dashboards.
For example, an explanatory field (black box) could be activated by a "mouse over" over an info field (i) (green circle). Example see screenshot
Miranda_1