Best Of
Important update regarding table view for free users (Viewers & Guests)
Hello Smartsheet Community,
We’re excited to share an update that brings you a more modern and collaborative way to work in Smartsheet — table view. Built on our next-generation platform, table view is designed from the ground up to support work management in current sheets while unlocking new capabilities now and in the future that will make it easier to manage work as a team in real time.
Starting January 12, 2026, free users such as Viewers and Guests (i.e., users without a seat or license on paid plans) will see the following change:
- There will be a one-time redirect to table view for existing sheets: the first time you open a sheet that was last viewed in grid view, it will automatically open in table view.
This redirect isn’t just a change, it’s an opportunity. When you switch back to grid view, you’ll be prompted to share feedback on what’s missing for you to work exclusively in table view. Your insights will help shape the future of the product experience, and we look forward to hearing from you.
With table view, you get:
- Real-time collaboration that keeps everyone aligned as changes happen
- Modern design and usability to simplify working across various projects
- A consistent and uniform platform experience across our new experiences, including board view and timeline view
If you are a free user, such as a Viewer or Guest, you can always switch back to grid view, but we encourage you to explore table view for both new and existing work.
To learn more about why we launched table view, read our original Community post. You can also explore these help articles to learn more:
- Introduction to table view
- Set up your sheet in table view
- Work with your data in table view
- Large scale sheets with table view
Thank you for helping us shape the future of Smartsheet and for being an active part of our Community.
Lekshmi Unnithan
Re: Generate formulas using AI in table view
you can ask ai to build a table first (columns like “input”, “formula”, “result”) and then tell it what each formula should do, it will fill the cells for you
if you’re in excel or sheets, just paste the ai-generated table and you’ve got all formulas ready to test
caroloo
Re: Meet Sam Harwart, our November Member Spotlight! 🎉
Outstanding story Sam!
It was a pleasure to meet you at ENGAGE 25.
Looking for ward to collaborating in the future.
Bruce Case
Re: Formula Help
@Amy Shank The issue with your formula is how you used the OR function. If it was needed, it would be used a little differently, but in your case, you do not need it at all.
=COUNTIFS([Event Title]:[Event Title], @cell = "Non-Public Schools Leadership Conference", [Admission Item]:[Admission Item], @cell = "Exhibitor", [Payment Method]:[Payment Method], @cell <>"Free")
A use case for the OR function would be if you wanted to specifically include certain statuses such as "CC" or "Cash".
=COUNTIFS([Event Title]:[Event Title], @cell = "Non-Public Schools Leadership Conference", [Admission Item]:[Admission Item], @cell = "Exhibitor", [Payment Method]:[Payment Method], OR(@cell = "CC", @cell = "Cash"))
Notice how we establish the range first and then use the OR to gather the criteria for that range.
AND can also be used in a similar manner. A use case here would be if maybe you wanted to exclude "Free" and exclude blanks.
=COUNTIFS([Event Title]:[Event Title], @cell = "Non-Public Schools Leadership Conference", [Admission Item]:[Admission Item], @cell = "Exhibitor", [Payment Method]:[Payment Method], AND(@cell <>"Free", @cell <> ""))
Notice how the syntax here is the same. We establish the range then use the AND to gather the criteria.
Paul Newcome
Re: Anonymous Survey
Generally speaking, I would say make the form so that is doesn't require users to log in and don't ask for any identifying data, but…
If the user is filling it out an a device that has the app downloaded, it will force them to log in at which point you could technically insert the [Created (by)] column and see who submitted the form for any entries done this way.
If the user is filling it out on a device that does not have the app downloaded, it will still remain anonymous.
It is only users that are filling it out on a device that has the app downloaded that won't technically be completely anonymous.
Paul Newcome
Re: Anonymous Survey
@Allex ,
You create a sheet with each question as a column then create a form based on those questions. Responses will be anonymous if you:
- Don't require Smartsheet login.
- Don't ask for the respondent's name or other identifying information.
Neil Egsgard
Business Solutions Architect
Southern Alberta Institute of Technology
Neil Egsgard
Re: formula INDEX, MATCH from two different sheets
That's a clever use of iferror(). It always seems odd to me to use error traps as part of the fundamental logic of the page rather than just to handle unexpected scenarios. But, particularly with your doubling up of the iferror() functions, this seems pretty safe.
Jgorsich
Re: formula INDEX, MATCH from two different sheets
Makes sense. I think part of what throws me on it is that you actually have to know your data and the smartsheet functionality even better to do it this way as you have to know that an error will be thrown (vs a non-error that just doesn't get your information). It is a clever and efficient way to write a formula - it is just never a route I think about using (like, in this instance, absent an indicator on the sheet I'd probably write some very long "if(countif()>0,index(),Index())" type of thing instead to check the sheet first rather than counting on the first index throwing an error). I can see where doing this is MUCH more efficient.
Jgorsich
Re: Add a row to a sheet via Global Update
Looks like, I've already upvoted that one!
Thanks all the same!
Nik Fuentes