Best Of
Re: Copying Cells to another sheet, formatting
First: The rows will be copied to the first UNUSED row in the new sheet. Even if a row is blank, if it previously had data in it before, it is considered used and will be skipped. Make sure to delete the rows themselves and not just the data from the cells in the row.
Second: Try converting the formula to a column formula.
Paul Newcome
Re: Smartsheets new User Subscription Model True Up Page is horrible
Thanks for sharing your experience. We were able to delay moving to USM until June 2026 and, hopefully, by then some of these kinks will be worked out. We have talked to Smartsheet about making the true up process more automated. Like, why not use a Smartsheet for the true up list and then have automations go out to the impacted users and ask them whether or not they want a paid license, want to downgrade to viewer or remove their account from our plan but Smartsheet insists on giving us a list of people in a UI and making our System Admins do all of the leg work. As it is, it is completely unreasonable and very poorly designed. We don't use Okta so we don't have a way of automating it from that end. We expect to take some steps to prepare for this eventuality during the upcoming year and to continue the process of evaluating alternate products in case the decision is made to exit from Smartsheet. It's only prudent to be prepared if the costs get out-of-control.
Stu Benoff
Re: New streamlined creation experience
Hi there, @Julie Becker,
Thanks for taking the time to share your feedback - we really appreciate hearing from you.
I wanted to provide some context that might help explain our approach:
User Research Insights: We've conducted interviews with users across all experience levels, from newcomers to long-time Smartsheet users. Interestingly, many of the experienced users we talked to told us they viewed the sheets folder more as a "catch-all" location and over time has become cumbersome and overwhelming. Instead, they've moved to organizing their work primarily through Workspaces, which offer better structure and collaboration features.
Listening to Our Community: We absolutely value input from both new and existing users when making UI decisions. Your perspective as an experienced user is incredibly important to us, and we want to make sure changes work well for everyone. We're taking all of your feedback seriously and are in the process of altering our approach as it relates to the sheets folder.
Technical Considerations: The Sheets folder has some unique technical architecture that's different from Workspaces. We've found that in some cases, when customers have extremely large numbers of items shared to their Sheets folder, it can create performance issues that affect not just individual users, but platform stability for everyone. Workspaces handle large amounts of content much more gracefully from a technical standpoint.
Please keep the feedback coming - discussions like this help us understand how changes impact different workflows and use cases.
Thanks again for being part of our community!
Best,
Jason
Re: Auto sorting
Hi @David Jensen, since this feature request has been requested a lot, I built a browser extension (SSFeatures) to add this feature into Smartsheet.
With SSFeatures, open the "Sort Rows" menu and then click on this "Sort Automatically" button. Then your data will automatically sort whenever it changes.
SSFeatures
Re: Check Box for Current Milestone
Give this a try:
=IF([Milestone #]@row = MAX(COLLECT([Milestone #]:[Milestone #], [Milestone Status]:[Milestone Status], @cell = "INV PKT SENT & PSR XL UPDT")), 1)
Paul Newcome
Re: Check Box for Current Milestone
Hello @Smar Czar ,
Can you please try the below as a column formula for "Current Milestone"
=IF(COUNTIF([Milestone Status]:[Milestone Status], "INV PKT SENT & PSR XL UPDT") = [Milestone #]@row , 1, 0)
Re: Changing the owner on sheets owned by Smartsheet Service Account
@kowal in the past, no. I will put in another ticket and see if anything has changed.
Pamela Wagner
Re: Welcome to the new AI Community!
Hello!
I started using Smartsheet in 2012 and convinced my boss at the time to ditch their spreadsheets and utilize Smartsheet for everything possible and I've been using Smartsheet ever since.
The company I've been with 2019 is a long-time user (former Control Center/Pivot/Calendar/DataMesh) and while we had to downgrade our Advance subscription, I'm pushing to establish a PMO use case for new neighborhoods in concert with our construction ERP.
I've been using the AI function in Smartsheet primarily to assist and repair my formulas which has been amazing.
Anne Slifka
Re: Automation emails and text
This doesn't help but is more of a comment. I dislike that when we need something specific that a "helper" column is the only solution to generate a response. When you are working on a sheet that already has over 10 columns for intake/column formula/check boxes, etc. Creating multiple helper columns to create the desired outputs is definitely frustrating.
liz.mayeux
Re: Unable to click on individual cells
Hi @Kelly Fabiano,
Thank you for bringing this to our attention! We've determined that cells/sheets being unresponsive until the page is refreshed is caused by a bug and our Product team is working on a resolution. We are not able to provide a time-frame on how long the resolution could take but we are doing our best in order to have this fixed as soon as possible.
Thanks,
Georgie
Georgie