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 guys, my team is receiving the following error An error has occurred in Smartsheet Please log out and log back into the app before continuing. If the problem continues, please request assistance at www.smartsheet.com/gethelp. Recently Open Solution Center. Help We already did the proper troubleshooting like clearing…
I'm updating automations for a Sheet I created and when I attempt to add three people to receive the email notification, I get the "one or more recipients are blocked" message. If I have two recipients, it works just fine. All of the recipients have been granted access to the Sheet with Editor - Cannot Share access so, per…
Hello, I need some help fixing my sheet/formula/report. I have project sheets that all contain a formula to calculate a value. The sheets return the value fine but when i try and run a report for all/some sheets i get #BLOCKED. Even running a report for a single sheet that works, I still get #BLOCKED on the report. Any…
Hi everyone, hope y'all good. Im a PMO here in Brazil and Smartsheet ir our standard tool for management projects. Im tryng to create columns what we call "Trend curve" when we see the variaton of the real execution between the tasks, but when we set the project, it is impossible to put some condition in the cell…
I am tryings to create a risk formula for Program that has list of projects as a child. Following are conditions to mark the project as either Green, Yellow, Red or Blue: Blue: - Project has progress (% Complete > 0) but hasn't officially started yet (Start Date is in the future) - Indicates early progress or a potential…
I would love to be able to take action within a formula based upon which specific error the formula spits out. Right now, the IFERROR function catches errors but doesn't tell us what kind of error it is. It would be great if we could recognize different errors like #BLOCKED, #UNPARSEABLE, #DIVIDE BY ZERO, and others.…
It looks like you're new here. Sign in to post and engage.