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 have a sheet with stakeholder requirements for a software development project. The rows are the individual requirements. Our engineering teams are working in Jira so their work items are Jira tickets. I need to be able to sync the Jira ticket statuses to the relevant line item in Smartsheet. The status sync works fine…
Feature Request: Automatically Sync Reports When a Source Sheet is Renamed in Smartsheet When a report is grouped or sorted by Sheet Name, renaming a source sheet doesn't immediately update the report. The new name only appears after a change is made and saved in the sheet. Until then, the report continues to display…
HI, I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a unique row ID (to avoid pulling in the duplication of rows), without having to write individual formulas for each column? I've…
Please make it possible to Sync the Personal Settings>Profile details with an outside service, such as Outlook 365 Global Address List (Admin), OKTA, etc, so that the settings below are automatically populated. Since users will likely want to update the data or fill-in missing data, we'd only want it to pull the data into…
It looks like you're new here. Sign in to post and engage.