-
I am trying to count how many dates have a specific YEAR in a cell for a given row...
=COUNTIF([Date of first absence]:[Date of first absence], YEAR(@cell) = 2021) It keeps giving me #INVALID DATA TYPE
-
Help With Index Match (#Invalid value)
I am trying to return a Contact value Cell from a lookup table, in the Column "Assigned Contact Email" according to "Week * + Day*" and "Shift Assigned To" in that Row This is what I want it to look like. ^ This is the other sheet with the look up table. ^ This is the Formula I have used. ^ ^ For the formula, Red is the…
-
IF condition is true, copy a value into another column
I have a sheet where multiple people have to approve an item before it is 'approved'. I am needing to copy a cell from the Cost column into the pending, approved, or rejected column based on the current status. So if the P/R/A column equals "P" I need the $ in the cost column to populate in the Pending Cost Column, etc.…
-
COUNTIFS and NOT Formula Creation
Hello, I have a table of data that looks like this: I am needing to create a formula that will count all of the "1" in each column, that do not contain "OPEN" in the name field. So far I have created this formula: =COUNTIFS(Sun3:Sun27, 1, Employees3:Employees27, NOT("OPEN")) Does anyone have an idea for a formula that will…
-
NEW! COUNTIF not blank....
I want to count how many columns have a date in the "SMD/IME Appointment Date" row and where the "Case Closure Date" cell in that column is blank: =COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]))), ISBLANK([Case Closure Date], )) Attempt #2: =COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]))), ISBLANK([Case…
-
Formula to Return 3 Different Answers Based On Cell Value
Hello, I am trying to create a formula that returns 1 of 3 answers based on the value of the selected cell. Right now I have it set up to show me Complete/Incomplete based on the number 4 being in a column, but it would be more useful for me to see "In Progress" for cells that have a 1, 2, or 3 in them. My current formula…
-
Attempting to get sum of values from two sheets. Sumifs w/ Vlookup?
This question has been asked in a number of ways before. I have two sheets. All I am trying to do is get the total amount of pieces of equipment based on different criteria. Here is the first sheet: The first sheet is showing Requesting Garage as in the garage making the request for the equipment and "Garage" as in the…
-
Formula Help
I am getting an #UNPARSEABLE error in the below formula. The formula is to return "See Total Time to Close Column" if the Total Time To Close column is not blank, otherwise, perform the calculations. The calculation formula works correctly without IF(NOT(ISBLANK . . . part of the formula. (i.e., IF(NETDAYS([FAA Received…
-
I'm trying to combine these 3 Sumifs into 1 column formula...is this possible?
-
Formula Needed For Combining Rows with Exact Values in Separate Sheet
Hello Smartsheet Community, I have a compliance tracker sheet that captures employee's HIPAA and FEMA certifications. I have been tasked with creating a dynamic view for their immediate supervisors. I have two separate views for FEMA and then HIPPA. However, I also have employees who have submitted separate reports for…