-
Does anything in range A appear in column B?
I am trying to set up a formula that lets me know if any of the Project Tittles in one sheet appear in any comments on a separate sheet. When the function should return "True", I get "#invalid data type" =IF(CONTAINS({Project Tittle Range 1}, [Comments]:[Comments]), "True", "False")
-
Convert Quarters to Date
I have a list of dates that are Quarter/year (in a format like Q4 2031, Q1 2038, etc.) and would like to use a formula to show the last date in the quarter. So: Q1 2031 = 03/31/2031 Q2 2027 = 06/30/2027 Q3 2033 = 09/30/2033 Q4 2035 = 12/31/2035 I would appreciate help creating the appropriate statement!
-
Syntax error for nested IF statements
Hi there, I am looking to use a column formula to calculate review dates based on a few criteria. -If the 'Date of last review with no changes' is blank I want it to progress to the next IF statement: -If the 'Effective Date' is text I want it to return the 'Effective Date' -If the 'Effective Date is NOT text I want it to…
-
If Statement Help
I could really use some help! I am trying to write an if statement. Based on: Due date being < = -68 New entry is "starred" Entry 1 = "yes". I want it to be complete if it meets the conditions listed above and incomplete if it doesn't meet those conditions. This is what I tried: =IF([New Entry]@row = 1, [Entry 1]@row,…
-
Index Collect with an IF and a Join?
Good morning all I'm after help with a complex formula concept. FYI these are not live data sheets just moc ups. Data Base Sheet Metric Sheet Bellow is the formula im currently using to pull contracted orders across to a second Metric sheet. =IFERROR(INDEX(COLLECT({DATA BASE | Customer}, {DATA BASE | Start Date},…
-
How do I get this to work as I intend? Health Symbol Formula - Red, Yellow, Green, Gray
Hello, I've worked this many different ways, but cannot figure out how to get this to work. When I reordered the On Hold to the front, I finally got that working but then I saw the Completed < Today was red. I'm sure I'm missing something here and am fairly new to this. Will someone offer a little guidance to point out the…
-
NEED TO ADD DAYS TO THIS FORMULA IF ANOTHER CELL HAS SPECIFIC ITEMS OF A DROP DOWN.
I have this formula that works for this cell when information is missing from reference cell A. However now we want to be able to add additional days if reference cell B has specific items checked in a dropdown. I just can't seem to get it to work. Any suggestions. =IF(ISBLANK([ ENGINEER (tentative start date)]@row), "",…
-
Perpetual Renewal of Dates
I have run into a little issue with a formula. It isn't adding the renewal timeframe correctly Formula: =IF(TODAY() > DATE(YEAR(TODAY()), MONTH([Agreement End Date]@row), DAY([Agreement End Date]@row)), DATE(YEAR(TODAY()), MONTH([Agreement End Date]@row), DAY([Agreement End Date]@row)), DATE(YEAR(TODAY()) - 1,…
-
Multiple IF statements
Hello, I'm trying to make an IF( formula for the following criteria. If Tech is YES and Curved is YES, 650 If Tech is YES and Curved is NO, 500 If Tech is NO, 0 Thank you!
-
If Contains Contact Cell
I am trying to write what seems like a basic formula, but I'm not getting the expected result. I would like to reference a Contact Cell column with an If(Contains) formula. The basic formula I have written looks like this: If(Contains("John Smith", [Received By]@row), 1, 2). The result is always returning false ("2") even…