Discussions - Smartsheet Community

Browse Member Tips

HOW TO: Duplicate / Copy a Group
Smartsheet Support Documentation does not have a way to duplicate, copy, or export a group in admin.smartsheet.com/manage/groups There is, however, a workaround that doesn't appear to be posted anywhere so I'm sharing it here: Open the group in the group list at admin.smartsheet.com/manage/groups Select "View Group" Select…
Formula to add Months to Date
This is the simplest formula I can find to add Months to Date. This considers sum of months exceeding 12, converting it to January and adding 1 to the year. Where: Term column is the number of months to add, Date is the starting date. =DATE( YEAR([Date]@row) + INT((MONTH([Date]@row) + [Term]@row - 1) / 12),…
Pre-Filled Forms Using URL Queries: Tips and Tricks
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…

See all

Recent Discussions

Help Article updates December 2025
Hello Community, We’ve published the following new content. New videos on these topics: How to Use Tags in Brandfolder in Tag Assets How to Create Automated Update Requests in Request updates with workflows And new Help articles, including: Create linked dropdown columns Smartsheet Control Center glossary Identify your…
Column definitions report
we have to Validate any of the items we build that interact with FDA processes in some way (GxP, if you will). Something that would really simplify this process would be if it was possible to download a configuration file for a given sheet. Ideally, it would contain definition of all the properties for each column, and any…
QR Code integration for Graphic Production Tracking
Hello! We are a Graphic Production facility and use Smartsheet to track projects and their graphics from conception to completion. Each project has a workspace that is created with multiple matrices and we use a 'Production' matrix to keep track of all graphic items we are to produce. Our pain points currently have to do…
Column Linking Not Working - What am I missing?
I'm the admin of a workspace which contains 2 sheets: 1) "Source Dropdown Sheet" which should function as master dropdown list to feed other sheets (sample a US State dropdown column), and 2) "Source Sheet 1" in which I'm attempting to link the State column to reduce copy/pasting. However, after going through the process…
Created Date by column to show on line entries only
Hi How do i set created Date column to only show entries from line 24 downwards?
Intake Sheet column entries lost
Hi, Ive changed a column from Project Sponsor to Business Sponsor and it seems to have deleted the previous entries in the columns. I can rectify by looking in activity log but is there a quicker way to restore the previous data in this column
Help Article updates October 2025
Hello Community, We’ve published new videos on these topics: How to use columns in Insert, delete, or rename columns How to use timeline view in Introduction to timeline view Widget types in dashboards in Widgets for Smartsheet dashboards To view the entire catalog of help articles, visit the Help and Learning Center. Were…
Column filter not showing results
Hello! I am trying to filter for multiple items in a single column. The screenshot below illustrates the fields I am entering but when I apply it comes back with zero results. The value entered is the exact language as it appears in the cell. What am I doing wrong? Can anyone assist? Thanks!! Adding - Can you filter…
Add Quick Filters on Column Headers in Reports (like Excel)
It would be very helpful if Smartsheet allowed quick filters directly on column headers, similar to Excel. Right now, creating a filter requires multiple steps and saving it, which takes extra time for simple tasks. Having the ability to quickly filter a column by value, number, or condition (directly from the header…
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…
New column type: Currency-only
I see there’s already an idea requesting a "Number only" column type, and I’d like to suggest adding a "Currency only" column type as well. Currently, I have to create several workarounds to validate certain fields we collect. For example: Ticket number or Purchase Order number fields should only allow numbers and have a…
Columns have reordered
I have a question about Smartsheet. I have columns in my sheet for Monday, Tuesday, etc. Somehow, Monday moved to the end of the sheet. So, now Monday is after Sunday. I looked at the activity log, and it shows that the columns were reordered. How can I get them back to the beginning of the sheet, other than by dragging…
Default Column Sort Priority
is the ability to create a permanent default sort on a column (status) a feature request that is in the works or that will soon be implemented? having to create a helper column seems more like a work around instead of a solution. How this isn't a feature already when you already have sooo many amazing features is beyond me.
Synchronize Column Description, Input Form Help Text, and Dynamic View Description/Help Text
Allow for synchronization/harmonization of Column Description and Help Text fields across Smartsheet assets. The Column Description in Sheet view could be the default source of Help Text for that same Column in any Input Forms based on that Sheet, as well as the Description/Help Text for that Column in any related Dynamic…
Formula Range
Hello Community, Is there a way to make the range for a formula start at a certain row and then continue on once other rows are created? I've found that leaving the end of range number blank or putting a future number row that has not been created causes the formula to be Unparseable.
Board View no Names of Columns
Dear Community, I noticed that in the BoardView or CardView the names of the columns are not visible which make our cards very unreadable… is this on purpose or I am missing something? Those blue dots are symbols columns but now useless without the Name of what they represent.
Mode Function
A formula for the Mode of a column would be helpful. I have gotten help from the community members on alternatives with helper columns and have found methods online but having a set function would make the process more efficient.
Mode Function
Does anyone know if there is a "Mode" formula yet without using a helper column?
Cross sheet functioning column formulas working perfectly...except for two rows?
Problem Summary: I have a series of formulas and cross sheet references which grab display data that meet certain conditions. They are working consistently across usage…except for two rows? For data sensitivity, I'll only be including the date fields out of the display data, but the same error applies to all final display…
List of Automations that include a Specific Column
We have multiple automated workflows that may utilize a single column. Currently, the only way to know if a column is used in a workflow is either in the workflow builder view or when you attempt to delete a column used in a workflow. It would be awesome to see a list of all automated workflows that are currently utilizing…
Best practice to apply formula to columns
Hey y'all. I often catch myself stuck on applying a formula to a whole column. Is there a best practice or more effective way to apply formulas?

Welcome!

It looks like you're new here. Sign in to post and engage.