Trending in Formulas and Functions
-
Help with IFERROR addition to IF formula.
I've set up an IF statement to generate the quarter based off the month for our fiscal year. I want to add an IFERROR to the formula so suppress errors in cells that do not have a Purchase Date. Any advice is greatly appreciated! =IF(MONTH([Purchase Date]@row) = 1, "Q4", IF(MONTH([Purchase Date]@row) = 2, "Q1",…
-
COUNTIF with AND
I've written the statement but am getting a #INCORRECT ARGUMENT SET error. I'm new to SS, any help is appreciated. =COUNTIF(AND([Opportunity Risk Path]:[Opportunity Risk Path], [Module Approval Status]:[Module Approval Status], ="Conventional", "Not Started"))
-
IF CONTAINS Formula to return different text values in second column
Hi! I am looking for some help in creating a formula where if a certain word is found in one column, another word is returned in a second column. For example if "Head", "Nasal", or "Spine" is contained in the Procedure column, "Neuro" is returned in the Clinical Specialty column. I've tried different variations of this and…
