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 few sheets where users have access to it through collections, but are not shared to the base sheet itself. This is by design as we do not want the users in the raw data. When utilizing the comments function from a collection and mentioning another user, the notifying message/notification has the "go to sheet"…
When a user is shared to the Dynamic View but NOT the underlying sheet, @mentions in the Comments tab do not auto-populate and are rather useless. This makes no sense, as the purpose of Dynamic View is to prevent the need for sharing the underlying sheet and sensitive data. Communication should be able to be streamlined…
Users that are shared to the Dynamic View cannot be @mentioned. In fact, one user in question can CREATE a comment but then can't be found when @mentioned. How is this possible?
It looks like you're new here. Sign in to post and engage.