-
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…
-
Convert date field to month text
Hello! My goal: 01/02/2024 returns a value of January or January 2024 in another cell The column that contains 01/02/2024 is a formula calculating this date. I need to show the month (and year if possible) in text in another column. Is this even possible?
-
Index Match
I am trying to lookup 2 values Sales Order & Part Number on sheet 1 and match them in sheet 2 and display the amount. I have tried 2 versions of the formula with no success First one returns #INVALID OPERATION =INDEX({QuoteandSalesOrderLineDetailRev1LOResults3 Range 2}, MATCH(1, ([SO Number]@row =…
-
Multiple Select Dropdown
Hi all, I don't recall where I read that using multiple select dropdowns was not a good idea. I can't seem to find the reason why. I am creating a sheet that has up to 3 selections in one field and am questioning if its a good idea. Hoping to get the communities opinion on this before I continue with my sheet setup. Thanks…