Best Of
Re: Concatenate Formula in SmartSheet
You could use: ="st"+[Location Number]@row+"manager@email.com"
Re: ICYMI: Dashboard Charts Are Getting a Glow Up!
i too would like to know as @Paul Newcome mentioned
Julie Becker
Re: Capability to quickly grab Folder/Sheet Property Info from Workspace Panel
Absolutely love this idea - we should be able to get the same information/actions from the Workspace panel as we can from Browse!
Re: Progress Bar
You could insert a helper column with a basic formula of
=COUNTIFS([First Date Column]@row:[Last Date Column]@row, ISDATE(@cell))
Of course update column names in the formula to match what you are actually using in your sheet.
Then create a report that brings in all rows and only shows the Address column and this new helper column. Then use the report to feed your chart widget.
Paul Newcome
Re: NEW! Modern forms submission experience with accessibility enhancements
Thank you again for raising concerns around the recent changes to the Smartsheet form experience. We recognize the disruption this may have caused, especially in tighter layouts, and we sincerely appreciate your patience and feedback as we work through it.
As part of the Modern Forms update released on June 23, we introduced several accessibility improvements. These included larger font sizes and increased spacing to enhance usability for all users, including those with vision impairments. While these changes have significantly improved overall accessibility, they have also introduced challenges in more compact layouts. This includes forms embedded in dashboards and those accessed through mobile browsers.
In these constrained environments, the increased margins and font sizes have reduced the usable space for form descriptions and fields, making the experience more difficult. After hearing feedback from multiple customers and receiving your report during our July 3 sync, we immediately escalated the issue through our support and engineering teams using case ESC 18069. Our team is actively working on a fix that will detect compact viewports and dynamically adjust spacing to better suit these scenarios. This solution is designed to retain our accessibility improvements while restoring usability in tight form layouts. We expect this update to begin rolling out early next week.
We will continue to monitor and refine these updates to ensure a consistent and accessible experience across all form use cases. Your feedback has been instrumental in shaping this work, and we welcome any additional examples or context that may help us further improve the solution.
Re: Table view initial release is now generally available for all customers!
Good news, thanks for the reply
Re: Table view initial release is now generally available for all customers!
On my gods this is AMAZING! It will make the data collectin part of my life so much easier and faster! Thank you! 😀
Re: How to request task updates from collaborators
Happy to help!
Yes, they would still need to log in so we know who they are, but they don't need a license. And it provides many benefits. One of the most significant benefits is that they don't need to fill out everything at once, and they can have multiple updates running simultaneously.
Unfortunately, there's no built-in way to enter the updates, but if it follows the same structure, it could be set up to work with a parser and/or an AI service.
Would that work/help?
✅ Remember! 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: Formula VLOOKUP or maybe an alternative solution
You would need an INDEX/COLLECT combo for this:
=INDEX(COLLECT({Column To Pull Over}, {AJ_Number}, @cell = [PI or Account #]@row, {AJ_Name}, @cell = "Travel"), 1)
Paul Newcome
Re: July Question of the Month - Join the conversation and receive a badge
To carry on with the grief while honoring his memory by finishing and publishing his book. I’m two-thirds of the way there…
MMcLain
