-
Help with formula using YEAR function
I have a need to count rows where: Issue Type = Story Labels include LND-Product Status = Done Year of Resolution Date = 2020 COUNTIFS({JIRA Tickets Issue Type}, "Story", {JIRA Tickets Labels}, "LND-Product", {JIRA Tickets Status}, "Done", YEAR({JIRA Tickets Resolution}),= 2020)) Says the cell is Unparseable but I cannot…
-
Automatically update current stage
Hi, I am trying to track progress through various stages of publication (the columns titled approval, data collection, analysis...accepted). I thought the health bubbles may be a good way to quickly visualize progress but it is confusing the card view as it can only organize per specified column at a time. What would be…
-
Long Decimals - 7 digit decimals
Good morning, I have specific coding for each line item that reads as 7 digits with a "." followed by another 7 digits. So in essence, it looks like a long decimal. Smartsheets thinks it's a decimal and rounds it up, eliminating the last 2 digits when I leave the cell. Losing the last 2 digits changes the number and messes…
-
Combine a column from two different sheets ="Complete"
I am attempting to take info from a column from two different sheets and combine the total. The formula I am working with to perform this for a single column is: =COUNTIF({Project Plan - Project A Range 1},="Complete") I tried using the following: =COUNTIFS({Project Plan - Project A Range 1}, ="Complete", {Project Plan -…
-
"SUMIFS" with "AND" and "@cell" combination returning wrong value
Where [Begin]@row = DATE(2020, 7, 1) and [End]@row = DATE(2020, 7, 31) The following formula returns returns incorrect value: =SUMIFS({Maint-MLR-LaborHours}, {Maint-MLR-DateCompleted}, AND(@cell >= [Begin]@row, @cell <= [End]@row)) But, the following formula returns correct value: =SUMIFS({Maint-MLR-LaborHours},…
-
How do I reference the contents of a specific cell in a different sheet in the sheet summary?
Hello, Basically, I am trying to write a formula in the Sheet Summary of a sheet that shows the contents of another cell on a different sheet. I am able to write a within sheet cell reference for example, =[Latest Update]77. However, I want to change that formula to reference a specific cell from a different sheet. I've…
-
How to get an average of multiple symbols (harvey balls) on a single row?
Hi, I have a form that once completed populates a sheet. The form has about 100 items. The idea is that 100 items represent 5 categories. For each individual that completes the form I need to provide an average from the 100 responses that correlate to each category. I have the columns next to each so I can use the "range"…
-
Summary Sheet
Hi when i run a summary sheet, if the sheet uses drop down cells it does not pickup all the items I want to count. for example if i have Internet Access and TV Systems in same cell it does not count the Internet access when i try to do a counitIF. it only counts the cells where i have "Internet Access" only in the cell. i…
-
Find most recent updated status for category
Hi all, I'm searching for a solution on following idea: I have a sheet with following four columns: Created (date) | Category (Dropdown) | Previous Status (RYG balls) | Current Status (RYG balls) Now I want to auto-populate "Previous Status" with the last "Current Status" of the same "Category" when a new row is entered.…
-
Updating a cell based on checkbox column and a multi-select column
Hi there, I am new to SmartSheets and am struggling to use the CONTAINS formula. I need to allow for the option for [Trial Type] to be either Sales Strip, Sales Demo, or both Sales Strip and Sales Demo The formula below doesn't work if both Sales Strip and Sales Demo are selected. Do I need to use the CONTAINS function? Or…
