
What I love most is how it handles Sheet Summaries and hierarchy. Unlike a standard spreadsheet, where formulas get buried in the grid, Smartsheet lets me pull high-level metrics like my weekly completion rates into a separate sidebar. This 'hidden brain' approach keeps my task list clean while still feeding live data to an executive dashboard.
The Column Formula feature is also a massive time-saver. Once I set up the logic for parent-child row assignments, I didn't have to worry about broken links or manual entry every time I added a new task. It feels like a robust database that happens to look like a familiar grid. Review collected by and hosted on G2.com.
The formula syntax can be a bit of a headache at first. It’s not quite the same as Excel or Google Sheets, so I ran into some #UNPARSEABLE errors while trying to set up my hierarchy and week assignments. There's definitely a learning curve to figuring out how the sheet interacts with the summary sidebar.
Also, it’s not always intuitive that you can’t just copy-paste text between cells using automation. I had to change my workflow to a manual copy-paste for rolling over tasks because the platform is more rigid than a simple spreadsheet when it comes to moving data around automatically. Review collected by and hosted on G2.com.
The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user.
Validated through Google One Tap using a business email account
This reviewer was offered a nominal gift card as thank you for completing this review.
Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review.






