-
Formula to only count unique cells, no duplicates
Hello again, is there an =countifs formula that can be used to only count unique cells which would avoid counting duplicate cells in that column? below i want to count W01-W06 only once for the answer to be 6 instead of counting all the duplicate W01 to =8 thanks!
-
Row copying over twice
Hello :) Our Metric Archiver tracks the number of units we recieve, wash, process, etc. daily. The last 2 years we have only been dealing with towable units. We recently brought in motorized units, so I updated colums to reflect towable and added columns to reflect motorized. Here is a screenshot of that sheet. This sheet…
-
Display name based on maximum value
I have a field of Patrollers, they are using a form to enter interactions with customers. In my sheet I have been able to create a summary report that counts the various Interactions by Patroller breaking out (Guest Assist, Violation, Slow Zone), cant get the sheet to Sort my count... But what I am looking for, and it…
-
Multiple IF(AND criteria with NETWORKDAYS?
I am trying to use NETWORKDAYS with two criteria: whether there was a value in [PO Issues] + whether or not it was checked/addressed in [PO Issue Resolved]. My current formula is: =IFERROR(IF(AND([PO Issue Resolved]@row = "false", ([PO Issues]@row <> "", NETWORKDAYS([Quality Control End Date]@row, [Receiving Completed…
-
is this possible? - form fill, populate time, then multiple sheets update based on time
We are trying to automate some contractor time submissions. Can we: bi-weekly time sheet - create form that; form pulls drop down contractor name from separate sheet (contractor pay rate). Contractor enters job name from drop down option, enters hours for the week, enters email address and uploads sign off form. can 2…
-
Why am I get an error when I added IFERROR to formula:
=IFERROR(YEAR([Current Charleys GO]@row) - YEAR([Walmart Revised GO date from 7/8]@row)) * 12 + IFERROR(MONTH([Current Charleys GO]@row) - MONTH([Walmart Revised GO date from 7/8]@row)), "")
-
Invalid Data Type when Date column empty
Hi all, I'm using the formula below to calculate the NETWORKDAYS between the date an invoice was submitted until it is paid, if it has not been paid it calculates the NETWORKDAYS with TODAY. The formula is working, however, I'm getting an error on every row that does not have a date sent for payment yet. Is there a way to…
-
Counting Completed Tasks For Dashboard Report
On the project metrics sheet used for dashboard reporting, I need to count the number of times a particular task has been marked as completed using a checkbox. Here is a screenshot of what I am trying to count (see green highlight). Here is what this looks like on the project metrics sheet including the formula that keeps…
-
Very simple stock take...
Good morning! I have a simple stock take i'm trying to sort out for daily use, ideally i'd like to input a value into the IN column and this would automatically add it to the value already in-stock and again for the OUT column id like it to subtract from the value in stock. Is there a way to do this? Many thanks.
-
Formula to add a number in a cell based on other figures
Hi hoping for any help I can get on this. Using the image as a reference. Im trying to make [Length score] show a number between 1-4. the scenario being if the length is 30 days or less it equals 1 and between 30-90 it would show a 2, between 90-150 show a 3 and between 150-365 show a 4. Would love any help on this people…