-
Jira Connector field sync error "Specify a valid value"
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…
-
Sheet Timeout & Performance Issues – Identical Copy Works Fine, Original Doesn’t
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…
-
Why is my line chart not plotting horizontally (flat) for the same value?
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…
-
Unable to Access WorkSheet
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…
-
Has Function
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…
-
Current User Report - "Current User" not showing as an option in drop-down menu
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!
-
Help Article updates - January 2025
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.