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…
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
I am looking to set up a formula where a status column gets automatically updated to a certain color based on the relationship of the % complete column and the end date column for each row in the plan. Examples of what I am looking for below. If % Complete = 100%, then Status Column = Green If % Complete < 100% and Target…
Hello Community, In the world of hybrid work and AI’s promises to transform the workplace, IT departments find themselves in the seemingly paradoxical position of expanding access to information while also protecting it from ever-evolving threats. Chris Peake, Smartsheet’s CISO & SVP, Information Security, shares how we…
It looks like you're new here. Sign in to post and engage.