-
Not able to set multi-select default values on a form?
Now that the multi-select field type is a new thing, it looks like when using that field type in a form, you're still only able to have the default value be one, single value?
-
RANKAVG Function - exclude cell from range
Hello, I am trying to use the RANKAVG function but cannot figure out how to exclude a cell from the range selection. My equation is: =IFERROR(RANKAVG([Total Score]@row, [Total Score]$12:[Total Score]$77, 0), ""). I do not want to include cells [Total Score]24:[Total Score]26, [Total Score]39:[Total Score]41, [Total…
-
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.