-
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}])))
-
COUNTIFS error
So, a simple formula (that worked before), is now not working: =COUNTIFS([Approved 2024 $$]:[Approved 2024 $$], "", [Targeted Area]:[Targeted Area], "Atopic Dermatitis") Even if I reverse the [Approved 2024 $$]:[Approved 2024 $$] and put it at the end; it won't look at that column and count those "out". It just counts the…
-
Symbol, Checkbox, Percent Complete formulas
I have a series of projects listed in a sheet (Sheet 1), each of the projects has a deliverable name. For each deliverable name I have a Symbol, a Checkbox, a Percent Complete, and the Person Accountable. In a separate sheet (Sheet 2) I want to return the results of the Symbol, the Checkbox, the Percent Complete, and the…
-
Sumifs error formula when summing duration time
HI, I have a metric sheet where it is comparing to see person exists on another sheet and if so calculate the durations assigned against all their tasks. I get an #UNPARSEABLE in the formula that I cant figure out. Can anyone advise? =SUMIFS({Michael Johnson Assigned to}, [IT Personnel w no Email]@row, {Michael Johnson…
-
Returning A Symbol Value From Another Sheet
Hi all! I am trying to return a symbol value from a cross sheet reference, and I am having a little bit of difficulty at the moment. I have 2 sheets, we'll call the first sheet (that I am trying to reference) "Trends", and the second sheet "This Week". In "Trends", every row represents a week, and ta the end of every row…