-
Expand Count formula (To provide a list of names from another column)
Hi All, This one may not be possible, but will drop it into here to see if it is, thanks in advance for your help. I have a "COUNTIF" Statement in place which is counting the number of times "Red" is listed in a column. In a corresponding column I have a reference to a company name which I would really like to display on a…
-
Is there a formula to return a value if all of the cells in a column contain a specific string?
Hi, This may be a naive question, but is there a formula to return a value if all of the cells in a column contain a specific string? This will be part of a nested IF statement that returns different project statuses. For example: if any cells in Column 1 contain “in-progress”, then return “In-progress”, but if all cells…
-
Newbie help :) If a cell is blank, display content from another cell
Hello! This is probably so simple but I can't seem to get it right. Cells: Name, Draft Name This is what I'm trying to do: If Name is blank, show draft name, else do nothing. =IF(ISBLANK([Name]@row), [Draft Name]@row,” “) Appreciate any help I can get. Thank you!
-
Change Date based on Symbol
Good day everyone, I've seen a lot of posts about changing a symbol based on the date, but none for the other way around. In my use case, I have a Priority symbol that is being filled in on a form. I need to create a due date based on the Priority chosen and the date the form was entered. I was able to build that initial…
-
Combine 2 IF CONTAINS formulas searching 2 ranges
Needing some help. I am running 2 sheets a master project sheet and an audit sheet populated off a form. I have an IF CONTAINS formula that works to check a checkbox on the master project sheet when an audit is populated in the audit sheet with a unique number. =IF(CONTAINS(UN@row, {Audit Template Range 1}), 1, 0) I want…
-
Help with translating text values into numeric values for graphs
Hello! I'm trying to create three (3) graphs with data we're keeping in a Sheet to go onto a Dashboard. There are 3 Teams that will each be one of the graphs, and then the data comes from a dropdown column and each option will be a bar on the graph. I'm having a hard time separating the data first by team and then second…
-
Dashboard Chart to Show Rolling 12 Months
I created a sheet that has a primary column for "product type" and additional columns with months listed for the next two years (Dec '20, Jan '21, Feb '21, etc.) which indicates the month in which those products will be implemented. I then have 3 rows for 3 different product types. This data is pulled from a Summary Sheet.…
-
How to input data into target sheet from a source without a unique ID
For context, I am mining public clinicaltrials.gov records to associate unique trial records with results publications. There are often multiple results publications linked to an individual trial record. I have a sheet of my institutional records, each record has its own row and is uniquely identified by a national…
-
Are you able to pull emails from a Contact column?
I have a few sheets where I am needing to have the data Presented with the individuals name, then the email address in the column next to it. I have come across a few articles that have suggested having a helper 'Contacts Sheet' to reference w/ =INDEX({Contacts Sheet Email}, MATCH{Name@row, {Contacts Sheet Name}, 0)) for…
-
Formula to count all instances of a value in specific column from another sheet
I am trying to create a formula that references another sheet and totals the number of times a specific value shows up in a column that allows multiple values (from a dropdown menu). I am using =COUNTIFS({insert reference to column on other sheet}, HAS(@cell, "insert specific value")), but it only counts the number of…