-
COUNTIFS counting mismatch
Hi folks, Any help appreciated with this...I have some miscounting and can't seem to work it out...arrrgh! If I filter my main sheet as follows: The result is a count of 16, which is correct. However, my formula to achieve the same on a summary sheet I have gives 17? =COUNTIFS({Business Area}, "Product Group", {Agreement…
-
Using Index with Collect to Copy information from one sheet to another sheet for an entire column
Hello, I have 2 existing SmartSheets: Sheet 1: A Master sheet with 2 columns: Sheet 2: Another Sheet where only the "Die Name" where "Is Die 1 New?" = "true" is captured. I have tried the following formula under row 1 under "Unique Die Name" in the 2nd sheet: =INDEX(COLLECT({Die Name}, {Is Die 1 New?}, "true"), 1) This…
-
Unparseable error with "IF"
Good day everyone, I'm having issues with the IF formula on Smartsheet. I tried to do it as I typically do it on excel but I think I'm missing something in here. Here's the formula that I'm using: The thing what I want to do is if the Growth is over 100%, I want the result ">100%" in the cell. If not, I want the result of…
-
Create a list from check marks in a grid
I need to pull data from a grid organized like this (with yellow items being being column headings): into a list that is structured like: I am stumped on how to do it. I do not own the original data so I cannot restructure it into a different form. Any tips? -Matthew
-
SUMIFS with Multiple Conditions and Two Children Rows
Hi! I'm trying to work out the SUMIFS formula for a summary sheet based on multiple criteria that will SUM from two different children sum rows. Row 3 and Row 42 have the SUM(CHILDREN()) formula in those columns. I can do it for one child row with the below formula for each but i need to add the two together.…
-
SUMIFS I think?
I am trying to count a total number of employees in a multi-select drop down and also only count those employees if they attended meetings in November, December, January, Etc. All of this data is absorbed via a form. My current formula is: =SUMIFS([Employees at meeting]:[Employees at meeting], >1, Date:Date, AND(@cell >=…
-
Formula to return different values
Hello, I am trying to write a formula to return one value if a certain criteria is met, and a different value if that criteria is not met. What I have is below. It's not working, but I'm not sure how to fix it. Any ideas? =IF(Dates@row <= $Dates$2, SUM([Actual Cumulative Labor]10 + [Planned Billable Labor]10), ""),…
-
FORMULA FOR IGNORING A BLANK CELL WITHIN A COLUMN WITH FORMULA SET
Hello, I want to count the number of days from task set vs the due date set. I know the formula for that which is NETDAYS however, on empty spaces that I don't want filled in, INVALID DATA shows. So I want to know how to ignore the formula on blank cells. Can someone help me please? Column names: Original End Date, New End…
-
Sheet Name within a Cell
Hello, I was wondering if it is possible to write the current SS Sheet name to a cell that you are working on? The reason that i am checking this functionality is due to how certain project plans are created within a Workspace and i need to filter out within a report. Thanks, Anthony
-
CountIf with Multiple Criteria + Mutli-Sheet Reference
Hello, I am trying to count total items in "Medium" item in PRIORITY Column that also have a status of "Done" in the STATUS Column. Both PRIORITY and STATUS columns are in the SCRUM: Communications sheet. Here's my current formula (which is reciving a #INCORRECT ARGUMENT SET error): =COUNTIF({ SCRUM: Communications…