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…
We have a Jira connector workflow set up that includes a dropdown field in Jira with a predefined set of values. The workflow is throwing an error when trying to populate the field in Jira with a value of "All - North America", but all of the other values work as expected, including another that is "All - UK". We've…
Hi everyone, I’m currently working with a Smartsheet that includes: ~30 conditional formatting rules ~1700 rows Multiple columns with INDEX/MATCH formulas Numerous columns with regular @cell formulas Numerous columns with various types of data Two Data Shuttle workflows that update dropdown values in two columns Multiple…
I have a line chart showing % change over months; for the same value, I have lines that are not displaying horizontally in the chart and are implying a slight increase/decrease has occurred. The percentages are a simple average of cells in a column. I've verified already that the cells contain the same whole #s (no decimal…
Last night, everything was functioning perfectly while I was working on a sheet. However, this morning, I'm encountering an error message (Error 48) whenever I try to open the sheet. It's visible in the folder, the error persists on different devices and platforms. If anyone in the community has experienced a similar issue…
I'm struggling with the HAS Function. I think understand how it works, but I can't get the syntax right or something. Here it is: I'm trying to count the number of times each of these Values is selected in a cross sheet reference. I'm using {EXP} as the column reference. I'm using the formula below in the table below, and…
Hi all. I'm creating a current user report, but "current user" is not showing as an option in the drop-down menu (see below screen shot). I built out this report previously with no issues and when I checked the filters today, the current user one wasn't working. Thanks for any insight!
Hello Community, We’ve published the following new content: Using helper columns in Smartsheet Control Center: Troubleshooting FAQ To view the entire catalog of help articles, visit the Help and Learning Center. Were the articles helpful? Let us know by providing feedback at the end of each article.
It looks like you're new here. Sign in to post and engage.