-
Merged: Strikethrough, for selective text
This discussion has been merged.
-
How to autopopulate % Complete based off of other cells entry
Hello, I am trying to autopopulate % complete based off of other cells YES/NO entries in the sheet. I have 5 criteria to determine if we get to 100% Completion or not: Columns: Paperwork Received - YES (add 20%) NO (add 0%) Samples Received - - YES (add 20%) NO (add 0%) HPCL Received - YES (add 20%) NO (add 0%) Hold…
-
COUNT(DISTINCT(COLLECT to count unique values based on multiple criteria
Hi, I'm trying to count the dates we've worked on a job site, but we have multiple ones. Of course, at first, I'm trying to calculate just for one criterion. So far, I've tried using the Sheet Summary: =COUNT(DISTINCT(COLLECT(Date:Date, [Site ID]:[Site ID], "CUPERTINO"))) As per my database, I have 80 entries for…
-
Countif / Countifs values are between "0" and "10"
Hi all, Struggling with a formula and could use a hand. I'm trying to display data which shows me how many values are outstanding between 0 and 10 days. I've tried a few formulas but none of them seem to be working, which is driving me insane! =COUNTIF({MS - Range 5} < 10) As shown in the above, i've even tried to simplify…
-
Formula for counting how many people have signed in each month, referencing another sheet?
I am trying to count how many people have signed in for each month referencing another sheet so that the number appears on my metrics sheet. The below is what I have at the moment but it isn't working: Trying to find how many people signed into Yard A in January 2023: =COUNTIFS({Yard A Date}, IFERROR(MONTH(@cell), 0) = 1,…
-
Dropdowns in a dashboard, is it possible?
I have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics. *The drop downs show their total sales for each month, and even quarter, down to how many projects they have completed…
-
How can I add a number of days to a date column in the same sheet?
Hi! I currently have a column that is supposed to add 14 days to another date column in the same sheet. The formula I'm using is: =["Date Column"] + 14 However, what I keep getting is "Apr 21, 2020 3:10 PM14". Both columns are date columns. Thanks so much in advance!
-
Average Collect Issues
Hello! I'm trying to write a formula that will average the amount of time a type of request takes to complete by month. I'm referencing another sheet in this formula and just can't get it to work. Here's what I have so far: =AVG(COLLECT{Hours to Complete}, ISNUMBER(@cell), {Request Type}, "Quote Request", {Submitted Date},…
-
Overall Project Status based on frequency?
Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Completed. I am trying to set up a formula that will return the most frequently populated Status per unique Group and also…
-
Using INDEX MATCH Function with a Multi-Select drop-down column
Hello, I am trying to use an INDEX MATCH function to fill in the Transmission Region for the Sites Under Consideration, but am running into a problem when there is more than one site selected. I believe I need to add the HAS function, but have tried several ways and can't seem to make it work. Any help is appreciated!
