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'm building simple asset tracking system with Smartsheet and would like to have the row links as QR-codes that would then be printed as asset tags. I have not been able to find a feasible solution for pulling the row links for each asset (row). Doing manual copy paste for >2000 rows is not very convenient. I have a column…
Hello. I'm looking for some feedback on a control center process we've built. We have an intake sheet with standard and optional department assets depending on intake data. To mark which assets we need to create, we have multiple columns with multi-select dropdowns for each asset by department name. What my goal was to…
It looks like you're new here. Sign in to post and engage.