-
View a Full Calendar Year in Calendar View
I am new to using Calendar View. I have been searching around and messing with it today, hoping to move our district's PL calendar into Smartsheet (I currently build it in google sheets). Is there a way to view a full calendar year in calendar view? (We are a school district so I would want it to show July 1, 2025 to June…
-
Sum based on two columns, words and sum numbers
Hello, I am trying to figure out a formula that will SUMIFS my first range says "Perfect Match 111" and my second range has a number in it. Example if "Perfect Match 111" is in my first range 3 times then I want it to sum the number that is in my second range. So below I would want 6 to come back to my sheet. I have tried…
-
How to reset my Autonumbering
So after removing and deleting the test data in our sheet our auto numbers are not resetting to start at 1. How do I clear the phantom rows, or cache?
-
Protect Integration-Critical Columns and Rows While Still Letting Admins Add Content
In our organization, Smartsheet sheets are more than collaborative tools — they act as data sources for integrated applications, dashboards, and automation workflows. These integrations rely on specific columns, rows, and cell references remaining consistent over time. However, users with Admin rights can currently rename,…
-
Sharing of Smartsheet
When creating a Smartsheet/not workspace, we want to automatically share admin rights and editor rights with the same people on every sheet. Is there a way to automatically do this, without manually entering the names on share button after creation? thanks Amy
-
Excel Export without hidden columns
This idea has been lurking around in the community for years already, but never has made it into an idea. The idea to remove a data protection concept error in Smartsheet. As an editor you cannot see what's in hidden columns and you cannot make them visible. Makes sense because not everyone should see some content in a…
-
Automate a pre-set format and conditional formatting when using "save as new" with an external sheet
From a sheet that is shared with me from an external company, I'd like to know if there's a way to "save as new" within one of my company's workspaces but have it automatically mapped with my pre-set conditional formatting and column setup that I would like to use. Currently with each sheet that I save as a new sheet, I…
-
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…
-
Template for stakeholder analysis
Hi, I can see the download for this resource but is there a template in Smartsheet that I can use as a basis ? Free Stakeholder Analysis & Matrix Templates: All Formats Thanks !
-
Issue with unable to save a project template in the same folder
Hello Community, I am having a challenge in saving a project template in the same folder, when I am trying it to save as new it gets saved in the sheets and not in the same folder, even when I am trying to set the location it doesn't show options and also doesn't give any list when trying to browse, can any one help me.