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 wish to ADD the following to my existing formula: [Reporting Period]@row="Jan", "Jan" [Reporting Period]@row="Mar", "Mar" [Reporting Period]@row="May", "May" [Reporting Period]@row="Jul", "Jul" [Reporting Period]@row="Sep", "Sep" [Reporting Period]@row="Nov", "Nov" Here is my current formula: =IF(CONTAINS("-",…
Hi, I am working on setting up cross sheet references in SmartsheetGOV and it seems that the #UNPARSABLE error I receive is pointing to the token being broken. My formula is below. When I enter in "reference another sheet" it takes me through the steps to reference, but then it is inserted into the formula as plain text…
I am trying to replicate an Excel dynamic sum in Smartsheet. I have a row containing data for weeks 1 through 52. I want to sum the values starting from the current week (based on today's date) through week 52. In Excel, I used a dynamic range, but Smartsheet is giving me an error. How can I sum a specific horizontal range…
Im looking for a formula to calculate difference between two times eg 08:00 - 10:00 should give a duration of 2 but running into errors. I have column types as text number. 08:00 is named Start Time and column for 10:00 is finish time
I want to pull through the task name in one sheet where the check box at row is checked into another target sheet. This is what I though the formula would be but I get #UNPARSEABLE as the error. =INDEX(COLLECT({Task name}, {Stage check box}@row , 1)) Um, help please?
Hello, I am working on a sheet where orders will come in across the country and list local time. I need to be able to convert this time to mountain time regardless of daylight savings time. Anyone have any ideas? Also is possible to convert to the time to military time if it is received in standard time? Below are my…
I have a sheet conditional formatting has been applied so that Ancestor = 0 is one color, Ancestor = 1 is another. Ideally, I'd like to apply conditional formatting so that all rows with Ancestor = 2 are conditionally formatted to the automatic format style except for the last row which will be a different color. I'm still…
I have searched far and wide for a formula that may help me achieve what I need, to no avail. I have a data table that is updated weekly to showcase upcoming launches based on their scheduled launch date. I currently manage this in Excel but the data is currently on a Smartsheet grid. Ideally, I'd like to build out a…
Hello, This one is a bit tricky. I need to create a formula that will look at 4 columns in a row. If text is in any column in that row, based on the column the text is in will need to be text added to the 5th column. The words to enter into the LICENSE CATEGORY FORMULA column will be one of these 4 words: PHARMACY,…
Hello All, I am trying to figure out the best way to create an if statement. In my column RML Status if the status is RML-Current or In-TRL Current I would like my helper column to state ACTIVE. If it doesn't have either of these two status', I would like it to state INACTIVE. How would I go about creating this the…
It looks like you're new here. Sign in to post and engage.