Best Of
Re: Need to remove decimals from my Dashboard pie Charts. Please help.
Smartsheets - needs to revert back - the decimals need to be removed. This has also ruined all my dashboards and views. And my executive leadership also does not like the decimals nor the new views. not sure why this was even implemented without talking with end users. This is very bad - please change back asap. I can't even go back to the old views now. We also do not like the new dashboard version. It is not good.
Amackay
Auto Save / Invalid Operations Error.
Hi All,
I have been searching community forum to this unsaved issue that I am having with my PMO but no luck so far and appreciate if someone could help me with this.
According to what I have observed, the tasks sheet is not getting saved due to which some of the columns on Portfolio / Project Tracking Dashboard (Schedule at Risk, Overdue tasks, start date) are throwing error #INVALID OPERATION.
This error disappear if I go to the task sheet and manually save and go back to dashboards and refresh them, both dashboard started showing correct info. However it happens again after some time in a day or two.
I thought users forgot to save sheet when they do change their task status. To resolve this, account settings for all the users have been updated to auto-save after one minute of inactivity, so that the sheet is saved and error is gone.
However, I am still having same error #INVALID OPERATION in some of the projects on both dashboards. To fix I have to open task sheet and manually save again and again.
Here's the screenshot from Portfolio dashboard as you can see Schedule At Risk, Overdue tasks, Start Date is showing #Invalid Operation.
Same thing happens at project tracking dashboard. See below screenshot.
Below is the screen shot of tasks sheet and as you can see there's no other error except this sheet is not saved. So If I just save this sheet now and then refresh portfolio / project tracking dashboard both will show correct info.
Start Date is [date column] not restricted to date and has formula [(WORKDAY([Due Date]@row, -Duration@row)]Due Date is [date column] not restricted to date and has formula [WORKDAY([Due Date]$41, -[Days before OCD]@row - [Holiday Adj]@row)].
Appreciate if someone throw some light where / what to look for or what seems to be an issue.
Saj
Re: Seeking a remote full-time Smartsheet role
Hello Smartsheet Community!
I’m actively seeking a remote full-time role where I can apply my expertise in Smartsheet forms and dashboard design, automation, and visual workflow design to help teams operate more effectively and intelligently.
Here’s what I bring:
- Advanced skills using Timeline, Board, and Calendar views to create visually intuitive project environments
- A proven track record of using Smartsheet to manage high-impact initiatives where detail and coordination were key
- Strength in building automated workflows that eliminate guesswork and enhance consistency across tasks
- A creative eye for formatting and presenting data with authenticity and clarity
- Commitment to quality, efficiency, and continuous refinement—whether working with stakeholders or fine-tuning internal processes
I’m passionate about transforming messy workflows into clean, reliable systems that empower teams and highlight what matters most. If your organization values precision, creativity, and real results, I’d love to connect.
Open to opportunities, collaborations, and referrals where Smartsheet skills meet thoughtful execution.
Jacob A
Multi-column forms
It would be so helpful to be able to be able to design forms with multiple columns.
Gawly
Re: How to change invitation email to new smartsheet users
I have a training soon with Smartsheet support and will ask this question during the call and will post the answer when I have it.
Jfreni
Copy A Filter View
I would like to see an easy way to copy or download a filter view (or many filter views) and use it on similar sheets. This would be very useful on complex sheets where we have many pre-set options available for end users. I imagine it would be similar to the feature that allows an Admin/Owner to copy a Sheet Summary and then export it to other sheets.
When implementing updates on items that are not already in Control Center or part of a Portfolio, this would be a helpful tool. If it were available for individual filters to be shared with other users to help them build a similar sheet (vs share to group on the same sheet), it would also be a useful learning tool for new users!
H Brian
Re: SmartU New Offerings - Smartsheet Builder Path & more!
That's awesome @Isis Taylor . I direct Smartsheet University and I'd love to hear about your experience if you pursue these enhanced certifications.
And to everyone in the Smartsheet Community. Thanks for letting me hang out here 🫶. While designing all of the enhancements to the program we drew a lot of inspiration from Overachievers, Mobilizers, Spotlighted Members and other rockstars in this space as we worked to define "Smartsheet Greatness"
Re: Freeze Row
And here we are, 3 years later and still unable to freeze a header row.
Oh, but Smartsheet has "improved" the Sheets view so that we can't create and move sheets between folders! Everyone sure wanted THAT change!
MyHatIsAFish
Re: Freeze Row
Upvoting this feature as well. Desperately needed! We have several header rows and navigation rows at the top of each sheet, and every time we sort the sheet the header rows get sorted as well. Major pain!
bsn14