-
RYG Ball Automation
Hello, I am trying to automate RYG ball based on Y/N responses to other cells OR I could change the Y/N to also be RYG if that would make this possible. Essentially, my overall goal is to automate the RYG ball based on how 26 other fields are answered -- 13 or less are green = Red 14-19 Green = Yellow 20-26 Green = Green…
-
Updating a dropdown list originating in Jira
We have created a webform, based on a sheet that sync's information with Jira. The Webform allows users to create a Jira issue and update the SmartSheet. We recently updated the values in a dropdown field within Jira. This field is set to a two-way sync between Jira and SmartSheets however, we are not seeing the new values…
-
Can 'Working Days' settings vary per assignee in sprint planning?
Hi! Working with one of the Smartsheet sprint planning templates and would like to be able to set different working patterns as two parties contributing to the sprint. i.e. Team 1 work Mon-Friday 8 hour day but Team 2 work everyday except Friday. Setting the working days in Smartsheet for either Team means that the…
-
"Item is not currently available" error upon login
We have a number of staff who are accessing Smartsheet, some as registered users under the Team plan, and many others who have free accounts and edit sheets shared with them. On one user's computer, however, whether she logs in with her free account or I log in with my Admin account, the first thing that happens is a…
-
Can you select columns when the "copy rows" workflow is triggered?
Hello! I have two sheets for contracts. On the first one people will submit a contract via Smartsheet forms and with the copy rows workflow, the information entered will go to my master contract sheet. Everything works perfectly fine, the only problem is that the form people use to submit new contracts contains a lot of…
-
Linked cells not showing in dashboard report
I have a dashboard that surfaces a report in which the duration value cells is blank. The report source data is in a row report. The duration value is visible in the row report. The source the duration value is a sheet in which it is also visible. I have refreshed the report but as the duration is automatic I cant do much…
-
GLITCH? Text isn't wrapping nor doing a copy/paste correctly
Good morning, I've discovered that text is no longer behaving well within the cell. I'm see words cut off within the cell, whether or not the cell is formatted to wrap the text. Thus, it makes copying the text and pasting it wonky. I often have to copy/paste text from SS into Word. It pastes with embedded formatting that I…
-
Merge sheet to Google Doc automatically
Hi, is there a way to automatically merge rows to a google document when a new row is added? Example: We track phone monitoring in a sheet and want them to auto-merge into the Google Doc or PDF instead of someone having to do manually.
-
Move Row - System Column name ERROR
I'm working to have a request sheet move rows to a active list sheet. I'm getting the following error and having trouble finding information on what column name actions I need to look to correct. Any help pointing me where I can find column naming rules to enable the Move Row work would be appreciated.
-
Does a range of dates fall between another range of dates?
Hello, I have a need to be able to highlight if a range of dates falls between any other range of dates. I have a checkbox column which needs to be ticked if a range of dates conflicts with other range of dates. So for example, we might have a number of projects running throughout the year across different clients and…