-
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…
-
Week Number stopped working
Hi All, I'm a little stumped, I have a formula that worked great until last week when it stopped working. I figured it was just because it was week 1 and week 52 in the same week and figured it would all start working this week. No dice, any help is appreciated. The formula is a helper column that is meant to count the…
-
[help] multiple IF formula; ancestor function?
Hi everybody! I've been testing smartsheet for a month and I was just setting up a document by myself when I found a mistake in my own logic. This is the formula I'm using: =IF(AND(ISBLANK([delivered by]@row); [start date]@row > TODAY()); "to do"; IF(AND(ISBLANK([delivered by]@row); [start date]@row <= TODAY(); [end…
-
Nested IF function
Hi I am currently trying to create an IF function that will mark a row as overdue if in the 'status' cell is "Paid" or "paid through urgent payment". At the moment i have it working for just one criteria, =IF(AND([Days Until Delivery]@row < 0, NOT(Status@row = "PAID")), "OVERDUE", "") where do i add the second criteria…
-
Comments on a specific Row doesn't work, changing comment for one row changes for all other rows
Let's say i try commenting "This is a priorty level 3 task" on a Row 11. Now if I go to Row 23 it shows me the same comment as from Row 11, and if i change it for Row 23, it changes for Row 11 as well. Smartsheet is supposed to store these comment separately and not as same comment for all rows. Please help resolve this…
-
Why can't I choose the auto number column for my report?
I created an auto number column indicating a running matter number sequence for reference in my sheet and need to see it in various reports. I am not able to choose this column for the various reports. Why? Thank you.
-
Calculate average durations between dates
I have an original sheet with hundreds of rows of information (Source Sheet) that I am looking to summarize calculations in to a second sheet (Summary Sheet), in order to feed in to a dashboard. Source Sheet has two date fields that I am interested in - lets refer to them as an 'open' and 'close' date. I would like to…
-
Nested Formula for At Risk Flag
I've been trying to create a nested IF/AND function. I can get them to work individually, but the formulas are unparseable when I try to nest them. Below is an image of my sandbox where I am learning formulas. Here is what I am attempting to flag in the RISK column: If FINAL DUE is today or in past, AND If FINAL DUE is not…
