-
Formula to return a date that always lands on Wednesday
Hi, I'm trying to create a formula that takes a date and returns a date that is the following Wednesday. So it is always a date that starts on a Wednesday. This is the formula I've tried, but it's not working. =IF(WEEKDAY([Task Name]29)<=4,(4-WEEKDAY([Task Name]29))+([Task Name]29),(11-WEEKDAY([Task Name]29))+([Task…
-
Another Nested IF Formula
Could use your help again. Not sure why I have so much trouble with these nested IF statements but I do! When I use the formula below and the Business Unit is equal to EMEA, it returns ASD....any ideas? =IF([Business Unit]@row = "Biologics", "ASD", IF([Business Unit]@row = "Western", "ASD", IF([Business Unit]@row = "Simple…
-
Summary formula Sum of information
Hi All Can anyone please advise on how to quantify two columns in the Summary information? I want to look at the failure column to look for keywords then sum the amount of failed items. Example look for ... OTIF and the sum of issues should report 10
-
Bring the data in a cell over to another sheet based off of other conditions in a row
What would be the best way to bring the data in a cell over to another sheet based off of other conditions in a row? Example: =IF(AND({Sheet A Type} = "Project Status", {Sheet A Status} = ""), {Sheet A % Complete}, "0")
-
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 >=…