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…
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've noticed a few people asking for Speedometer Charts in Smartsheet, so I figured I would go ahead and publish this solution that I developed. It was some years ago, so there may be better ways and / or more efficient formulas, but this should at least help get everyone started… A few notes to kick things off… This…
Details of how to send Outlook emails using a template that is populated with Smartsheet data and triggered in Smartsheet. This solution is complex. Some details have been blocked out for privacy. I had to split this into two posts due to the length. 1 of 2 : How to send Outlook emails using a template populated with…
Hi! I’m trying to create an invoice using Document Builder. I saw a video where they had a parent row with child rows underneath, and the child row items appeared in the generated invoice as separate lines. In the comments, they mentioned that Document Builder only generates from one row, so the child row data needs to be…
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.