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 am attempting to do a lookup of a a Date (on the Deliverable Tracker, shown in screenshot #1). The lookup will use the Effective Start and End dates to find the appropriate range, then the end result will be the text value column at the far right. My formula shows a blank result, here is the formula:…
I keep getting this above error when synching my smartsheet with Jira
Greetings, I'm having a weird Smartsheet issue reported today where a bunch of rose have the same description from a previous row and they're not supposed to. I'm not sure how this happened because all of this information is submitted via a form, but I don't manage this grid. I know how to select the grid and say pull a…
This is unlikely possible with Smartsheet but I'd LOVE to be proven wrong :) I'm trying to Highlight Cells in the row that have errors. There might be one to twenty columns in that row with errors at any given time. Reason for it: One broken formula (or cell with bad data) can break several other formulas in that row. And…
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.…
All of my columns that are using the INDEX and MATCH function are now showing as #NOMATCH. was there a change made in Smartsheet? what will i have to use now instead?
I LOVE that when you are writing a formula in Smartsheet, the formula adds colors to the references as you make successful references to cells. And how it goes "Grey" if there's a problem in the formula: However, It would be VERY VERY VERY VERY VERY helpful if you could keep the PROPERLY referenced cells in color, and ONLY…
I have discovered multiple ways to create a error checking column that looks in all columns to see if there's a broken formula somewhere. However, all the ways I have found aren't very elegant and don't provide the type of details I want. Example: =IF(ISERROR([First Column in Sheet]@row:[Last Column in Sheet]@row), 1) This…
It looks like you're new here. Sign in to post and engage.