-
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…
-
simple COUNTIF Sheet Summery formula
need help with this simple formula for a sheet summary =COUNTIF([IEP Status], "NEW (not signed)", "Active", "Active (Needs Att.)") something is wrong with the formatting I want to count number rows that contain these specific drop down list values. I put the values in quotes but the parentheses from the drop down values…
-
Is there are "CHOOSE" function? Calculating quarter from dates
My manager and I have been trying to find a formula that would calculate the FY quarter based on the "Start Date". We haven't been able to use a lot of the formulas we found on the Community because our fiscal year starts in Feb. instead of Jan. We've found a couple of solutions that's working for us now, but it's really…
-
Using Index/Match to display multiple values in a cell
Hi there, I have two sheets and I am trying to use Index/Match to pull multiples values in a cell in Sheet 1, into another cell in Sheet 2. I'm using the following formula, but I'm only getting the first item in the Sheet 1 cell to display. Here's my formula: =INDEX({01 - Product Grouping}, MATCH([Product Name]@row, {01 -…
-
Index Match based on two criteria from multiple columns
Hello I am trying to set up a sheet reference based on two criteria (Center and Department). I have tried the index/match and that did not work, so I tried multiple variations of the index collect-- but that did not work either. See image for the sheet i want to populate the data and the reference sheet that I have the…
-
Query String to pre-fill a form
I am attempting to use JOIN to build a query string and I am able to do it however if the column I join has spaces in the entry, the JOIN only attaches the first word until there is a space. =JOIN([Join Column]@row:DlrName@row, "&DlrName=") results with a query string but only the first word in the column DlrName. How do I…
-
COUNTIFS with multiple criteria from multiple columns
Hi all, I have tried various different formulas from various posts on here but still keep getting Unparseable. I am trying to create a formula, linking from another sheet, to find the following criteria: If the row contains ANY of these values: "未着手 Not Started", "進行中 In Progress", "現場確認 Field Review", "保留中（予算）On Hold…
-
Help creating a formula that generates the current fiscal year
The following formula is #UNPARSEABLE. I'm not sure why. Please help. =IF(MONTH(TODAY())>=7, YEAR(TODAY())&"-"&(YEAR(TODAY())+1), (YEAR(TODAY())-1)&"-"&YEAR(TODAY()))
-
How to Join values from a reference sheet based on selections in a multi-select dropdown
Based on preliminary searching, it seems this may be impossible, but I am hoping to use values chosen from a multi-select dropdown to collect and join values associated with each dropdown in a single cell. In this example, a donation manager is choosing donation items from a dropdown with over 40 selections. In the column…
-
Trying to evaluate multiple columns with an IF statement
I keep getting a syntax error for some reason but can't figure out why. I am basically trying to set a status icon of 'Sunny" if the status of the risk is "closed" and if not closed, i am using the other icons based on the level of the risk. here is the formula: =IF([Status]@row = “Closed”, “sunny”, IF([Risk Score]@row <=…
