-
How do i write a formula to calculate YTD totals of a given category
Here is the formula i started with. It gives me a #unparceable response =SUMIFS(Amount:Amount, [Expense Category]:[Expense Category], Description@row), Date:Date, YEAR(@cell) = YEAR(TODAY())) Ive included a screen shot
-
Workspace - adding a new sheet to a folder - report is not picking up that new sheet
I have a question about workspace and folders and reports. I have a company workspace with 3 folders in it; Active jobs, cancelled jobs and completed jobs. I have a report that pulls from the active jobs folders, but when I create a new sheet that report does not automatically pull in that new sheet. My question is, what…
-
Addition of resources to Smartsheet
Greetings. The previous system admin of our Smartsheet account has left the organisation. How do we change the system admin now ? There is a need to add more resources to our account and we are not able to do the same. Kindly provide suggestions on what to do. Thank you
-
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…
