-
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…
-
Extracting email information from a contact column
I have a need to extract email information from the information in a contact column. My users occasionally need to copy and past email information into other applications. I know that if I reference a contact column into a text column that the name comes over as text. I need a way to do the same thing, but have the email…
-
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…
-
Check box for duplicate rows
Hi, I'm looking for some help with a formula. I have rows of request numbers, some are duplicates, and I'd like to have a box automatically check for the duplicates. The plan is to keep one of the rows then set an automation to move the row with the checkbox to an archive sheet, probably have than one set to run on a time…
-
Why is my VLOOKUP not working?
This is the formula I am using: =VLOOKUP([ANALYST PARTICIPANTS]@row, {SAFFS::Firm:Analyst}, 2, false) I have a separate Smartsheet that has a list of Firm/Analyst names that I used Data Shuttle to make. It has an attached .csv file with the data. SAFFS is the name of this Smartsheet. The first part of the formula is fine,…
-
What is Unparseable about this formula?
=SUMIFS({Daily Sales Tracking Range 5}, {Daily Sales Tracking Range 2}, >=[Week Start]@row, {Daily Sales Tracking Range 2}, <=[Week End]@row, {Daily Sales Tracking Range 4}, IF(CONTAINS("Better", [{Daily Sales Tracking Range 4}]:[{Daily Sales Tracking Range 4}])))