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…
Rows are numbered but columns are not. There should be sheet metadata available thru File / Properties that tells the user how many columns are in the sheet. This would be helpful for solution developers to know if they're approaching the 400-column limit without the tedious and error-prone task of counting them manually.…
Hi, a question about profile data in control center. If you mark the data as editable, when you edit the data in one sheet, will that update profile data for the whole project? If you mark the data as one time write, when you edit the data in one sheet, will that update profile data for the whole project? If you mark the…
Hello all! I am a relatively new SS Admin and would like some assistance understanding the Profile Sheet - Intake Sheet Relationship. I just added new data items to the Profile Sheet via the Global Updates in Control Center. However, in the new partitioned blueprints, there is no incoming (blue arrow) cell link from the…
Hello - I was wondering if community profiles could allow users to manage the information posted on their profile timeline. 🤔 For example, when I update my profile picture the activity and picture is posted on my timeline and it looks a bit messy (updating doesn't always work out as expected). 😂 Since anyone visiting my…
The user report generated in Plan Usage pulls in the users Job Category as the Department, instead of the Department listed on each user profile. Is there a way to customize the report, or another report somewhere that pulls in the correct department for each user?
For a period of time, 2 profile data fields were incorrectly set to One Time Write, rather than Cell Link. I need to correct this and add the Cell Link behavior for these 2 fields from the intake sheet to metadata sheets. I have tried the Add Profile Data trick to apply a pseudo Update Reporting Global Update, however that…
There is a way to link up Azure AD (Entra) to Smartsheet to automatically grant all users a Smartsheet account, it would be cool if their photo could also be auto loaded :)
We have one blueprint has over 370 projects and after 2 years in, our process changed and I need to add Summary row to one of the sheet. Currently we are unable to do this with Global update since Summary row did not existed before in this particular sheet.
It looks like you're new here. Sign in to post and engage.