Best Of
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
Re: Welcome to the online Smartsheet Community!
Happy to help with this, you can find the Fully Charged badge on your profile now!
Rebeca S.
Re: Columns not available in report
Hi,
I hope you're well and safe!
There are two different types of Reports (Row and Sheet Summary), and you've selected the Sheet Summary one. Try creating a new one and ensure you choose the Row Report option.
Did 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: Form field blocked
Hi,
I hope you're well and safe!
Unfortunately, it's not possible at the moment, but it's an excellent idea!
Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.
Here's a possible workaround or workarounds
- 3rd-party form service
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å