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…
Is there a limit to the number of columns in a spreadsheet?
When allocating hours to individual team members in SmartSheet the total number of hours transferred to Resource Management does not equal the total. I.e. When I assign 60.8 hours to an individual from 11/04/2024 through 11/29/2024 in SmartSheet, the total shown for the same Task in Resource Management is 54.7 hours over…
Hi, Community! Hope everyone is having a great week so far. Don't miss your chance to sign up for one of our upcoming Customer Success Office hours. Customer Success Office Hours are live small group sessions with our Customer Success team, focused on Smartsheet best practices. If you’ve got questions, we’ve got answers…
I'm trying to add 5 different logics. If question number 2 "does not contain" 24, 23, 22, 21 or 20 I want the error box to come up. I enter in the first logic step and it works, once I start adding more it stops working properly. Now, when ANY number is entered for question 2 the error box appears. What am I doing wrong?…
Hi All, I'm fairly new to formulas here on Smartsheet and have been racking my head over this one to no avail so far. I basically have two formulas that I am trying to combine into one, and each formula has multiple conditions. In the first formula, the conditions to be met are that if both columns of Date Received are not…
Hi, I wanted to know. Can I update data simultaneously in all the Smartsheets I own? If yes, please guide me. Thanks
📢 Calling all project management professionals! Are you ready to simplify your project and portfolio management to deliver results faster? Register for the newly released SmartStart Modern Project & Portfolio Management (Modern PPM) webinar with live Q&A! Learn More & Register Here! This webinar provides you with a…
It looks like you're new here. Sign in to post and engage.