-
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…
-
IF Statement
Hello! I was wondering if anyone could help get me started on carrying out what I think will be a very long IF/AND statement. See attachments - I've created a formula to read the department column and the output will be the employee that has been entered into the top grey section in the Assigned To column. My issue is that…