-
Return value if date falls within range
I have researched others' questions on this and I feel this should be right, but it's not. I'm trying to return the generation based on DOB: '=IF(DOB@row <= DATE(1943,12,31), "Traditionalists", IF(AND(DOB@row >= DATE(1944, 1, 1), DOB@row <= DATE(1959,12,31)), "Baby Boomers", IF(AND(DOB@row >= DATE(1960, 1, 1), DOB@row <=…
-
Using the IF and OR Functions in Combination
Hello, I am stuck trying to figure out how to use IF and OR in combination. I am using Smartsheet to track and monitor a project. I have an overview cell, Cell A, that I would like to show what overall phase my project is in, based on the statuses of the different phases in my project sheet. More specifically, I would like…
-
A formula for filtering out duplicates
Hi, I have a Production Schedule sheet that is inputted from our ERP system. I'm trying to make a report that shows all the orders not ready to go into production for the next 2 weeks. My issue is that the orders go through 2 stages and therefore have different start dates and show up as duplicates on my report. 1st stage…
-
Help with If formula
Hello, I am struggling with a formula, and would appreciate help. I can figure out how to get the 2 conditions I want, but not the 3rd. =IF(46 > [Time to Close]@row, "Quick", "Delayed", but I also want to add If( [Time to Close]@row, is between 46-60 ="Average") Any help is appreciated!
-
Vlookup and iferror formula question
I am writing a vlookup formula and I get a #NO MATCH Error. I want to remove the error and give a result of 0 which seems pretty straight forward. The formula I wrote looks like this : =VLOOKUP(SO@row, {Machine File Oven A Range 1}, 9, false) When I add the iferror formula it looks like this: =IFERROR(=VLOOKUP(SO@row,…
-
How do I get just the first 4 characters to the left of the text string (2700-insurance)
JOIN(COLLECT([2700 & 5090 Codes]@row:[6000 Codes]@row, [2700 & 5090 Codes]@row:[6000 Codes]@row, @cell <> ""), ", ") I need to get the first 4 numbers to the Left of the text string from each of the columns and output to another column. there are 9 columns that I will be collecting from. Thanks for any help
-
How do I create an IF for a line of cells that if true picks multiple values from cells?
Hi, I'm trying to do this elegantly =SUM(IF(E7:U7="x";value1 for E7, value2 for F7, value3 for G7...;0) Can it be done?
-
Is it possible to hide dates in a project plan and display week 1, week 2, etc.?
I'm setting up a project where the start date is still to be determined. I have been asked to provide a column that has the week a certain activity needs to occur in. For example, instead of kicking off the project on 25/09/2023 the Grid View of the project plan should have a column in it that shows the project kicking off…
-
Nested If Contains Function Returning #No Match
Having and issue with a nested =IF(CONTAINS( function returning a result of #NO MATCH. Formulas work independently of each other just not nested. I also confirmed the "search value" within the VLOOKUP is on the lookup table. What am I missing? =IF(CONTAINS("ABC", [DC Location]:[DC Location]), VLOOKUP([Lane Concat w/…
-
How can I do something like IF COLUMN CONTAINS A VALUE???
I have a Project Plan (PP) sheet and Project Metadata (PM) sheet. From the PM sheet, I want to search through the entire "Status" column in the PP sheet to see if any cell contains "On Hold". I've already created the reference from PM to the PP Status column and named it {PP - Status}. I'd expect this to work, but I can't…