-
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…
-
Stop lower row automatically copying colours from row above
I have a ticket tracker template being used at the moment, and every time a new ticket comes through from the form, the new row is formatted like a header (dark infill, bold type etc.) - how do I stop this row from being formatted like a header, and instead having it formatted like a child row should be?
-
Adding an Amount from a Prior Week
Hello, I am currently trying to get a sum from two values. One of the values is from the most recent Sunday, and the other is the Sunday prior to the most recent one. I need to find the difference of them for a calculation I am using in another column. I am not sure of how to call upon the prior Sunday's value. I do have…
-
IF/AND Function Across Different Sheets
Hello, I am trying to get information from one sheet to populate another sheet. The formula I am trying to use is: =IF(AND({Equipment} = "MIGU-1", {Status} = "Open"), "Deployed", "Available") I get an #Invalid Operation error. On sheet 1 is the data I'm trying to separate out... using the "Type of Equipment" column and the…