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…
How do you go about archiving large data sets from sheets? I know you can create automations to move rows to another sheet but what happens when that sheet gets too large as well? I have thousands of entries that happen every day and I am trying to use data shuttle to offload the data but with offloads, it just replaces…
Hi! I would like to know if it's possible to take my sheets and export (including attachments) into a zip file so that I can save in Sharepoint? I found I can export using data shuttle (or just to excel) to put in Sharepoint, however, I cant figure out how to also download the attachments saved on the sheet without doing…
Provide a way to bulk archive assets and automatically remove all sharing, deactivate workflows, etc. (similar to Control Center). Current method of manually removing sharing and deactivating workflows on thousands of sheets is too time consuming.
It looks like you're new here. Sign in to post and engage.