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…
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),…
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…
I understand that in the non-Government version of Smartsheet, there is an option to populate a drop-down list column with values pulled from another sheet. Does anyone know if/when this feature will be available in the .gov (Government) version of Smartsheet? If so, will the drop-down list dynamically update as the source…
With dropdowns only being able to be formatted as text/number this often necessitates the creation of extra formulas, automations or data shuttles, just to get the data back into the original format. It would be incredible to be able to use a dynamic dropdown of contacts or dates directly. With the future introduction of…
Still looking for documentation, but I am curious about the limitations with the dropdown linking in Table View. Does a person need to have access to the dropdown source sheet in order for the dropdowns to populate on the Table sheet?
Hi, I am trying to setup 2 drop downs in a grid sheet. The user will select from the first dropdown (parent) A, B, C and based upon what they select i only want to show the corresponding options in the second dropdown (child). So for A show 1, 2, or 3 For B show 4, 5, or 6 For C show 7, 8, or 9 . Using a form is not an…
Hey Community! Your forms just got smarter! You can now use linked dropdown columns in your sheet to automatically hide options as they are claimed. This is a perfect solution for tracking inventory or booking slots without worrying about over-selection. If you'd like to get this setup, all the info you need is in this…
Good afternoon, I am trying to utilize Linked Dropdown Columns for a manual process we have. We have many sheets that use a "Client Name" column with a dropdown list. Whenever a new client comes on or exits, we have to manually update every sheet that has a Client Name column and update the dropdown list. We do not have…
November 05, 2025 Dynamic Dropdowns has long been the #2 most voted public product request. When we hear customers talk about dynamic dropdowns we hear them talk about two specific needs: Available Now - Linked dropdown columns: Keep dropdown lists across many sheets in sync In Planning - Dependent logic in dropdowns:…
It looks like you're new here. Sign in to post and engage.