-
Trying to match values from different sheets
So I have the master sheet that has a Machine Name column, and I'd like to match it to a Department that is inputted in a separate sheet. Sheet 1 has 2 columns, Machine Name and Department (this is where the formula will go). Machine name is constantly added with random names being chosen out of a drop down selection from…
-
Index/Match works on all rows except a couple
Hello, I have a strange issue where my INDEX/MATCH formula seems to work on all rows except, for example, this one below. This is a listing of requests for a client. I've hidden certain columns for privacy, but the hidden columns are not used at all in the formula. Every request has a unique ID (primary column). There are…
-
COUNTIFS for whole Sheet
Hey, This is probably an easy fix but I am having no luck. I want to count if anywhere on a sheet has a "4" in a cell. I also want this to separate the counts by "ITCMW", "ITCT" & "METC" My current formula is: =COUNTIFS([Pre Trip Completed]:[Doors/Gates], HAS(@cell, "4")) I need to include System:System, "ITCMW" in this…
-
Formula - Cross Sheet Referencing
Hi Community, I’m trying to cross-sheet reference. After I type the start of the formula, the box to “Reference Another Sheet” appears. I clicked it, found my sheet, chose the column, but the “Insert Reference” box remains grey. I’m the owner of both sheets. What am I missing? Screenshots attached. Thank you!
-
IF AND Formulas for Flagging
Hi again, I am trying to have flag a parent row based on 2 separate criteria: 1) if the overall risk score is <50% and 2) if any Children rows have any High Risk questions Flagged I have tried it a couple of ways still receiving #IncorrectArgument and #Unparseable Below is #IncorrectArgument For #Unparseable: =IF([Risk…
-
Status Indicator formulas
I have been working on this for two days and I finally decided to ask for help. I am trying to achieve the following: If Dev Progress is marked as "complete" then "Blue" If Dev Progress is marked as "In progress" and Today is between Start date and End date then "Green" If Dev Progress is marked as "not started" and Today…
-
Formula in a dropdown menu
This is what I am trying to do... I need the total of "amount Due" if "invoice" is selected. And the Total of "Amount Due" if "On Order" is selected. I would like for that info to populate at the top Help!
-
COUNTIFS Across Different Ranges Returns #INVALID DATA TYPE
Hi Smartsheet Community, I am stumped. I have a COUNTIFS formula that behaves as expected on my test sheet but returns an #INVALID DATA TYPE error when replicated on a actual sheet. The Column Types and formatting are the same on the test sheet and actual sheet. I would like to count the number of instances where Unit…
-
Large criterion name
Hello, I'm trying to make a formula to count the number of jobs by builder for the month of January to go into my sheet summary. I managed to get the formula working for January however when i copied and pasted the formula and changed the name of the builder i got #invalid operation. The working formula is as follows,…
-
Help with returning value from two criteria
I want to fill the empty green field by matching the yellow and blue fields. I've tried Index collect and index match match. =INDEX(COLLECT({QuantityOverview}, {PPEReceiptOverview Range 1}, Name@row, {PPEReceiptOverview Range 2}, [1 Quantity]1, 1)) returns #INCORRECT ARGUMENT SET