-
Formula Error/Mistake
Hi all, I have a formula that autopopulates only certain cells. Now, it works fine in my other sheet, however, I had to do slight adjustments to it in this sheet and it clearly populates the correct cells, however, it is not giving me the correct value, and instead just puts 0.00. Can some please help me figure out the…
-
Can you match between multi select dropdowns?
I'm trying to match values between two multi drop downs. In one sheet there are rows that are associated with multiple groups, in the summary sheet are the groups that are selected. Is there a way to write a formula that will look at the summary values in the dropdown and see if any of those values exist in the second…
-
Returning a value based on multiple criteria
I am trying to autofill a summary table using formulas. I am able to autofill the monthly counts using date criteria, but I can't get the total numbers to autofill. I tried using the below formulas to pull from the two places where I have the counts for total members and total new members of each member type, but I keep…
-
Count and provide unique numbers
My need is to provide a unique and incremental number for each row, so when a new item is added it gives it the next number in that category. The current formula is =COUNTIFS(Created:Created, <Created@row, Type:Type, Type@row) + COUNTIFS(Created:Created, Created@row, Type:Type, Type@row) However, because it's based on the…
-
TEXT to DATE Formula
Currently we are using an API to upload a "date" into our sheet, but can only upload it into a text column without causing errors with the API. To transform it into a date column, I have created another column that uses a formula to covert the text uploaded into a date format. However, I'm having troubles simplifying the…
-
Countif and Contains formula
Hello, I am needing a formal that counts items that are the following: Range 1 = Consultation Range 2 = Completed Range 3 CONTAINS Ute Mountain Ute Tribe The below is what I have, but it says it is umparseable. =COUNTIFS({CDHS Tribal Team Range 1}, "Consultation", {CDHS Tribal Team Range 2}, "Completed", ({CDHS Tribal…
-
5x5 Risk management formula
Can anyone figure out what's missing in this formula to set a rating from a 5x5 risk matrix. I copied the format from the risk assessment matrix template set that is a 4x3 matrix and modified. =IF(AND(OR(Likelihood5 = "Rare", Likelihood5 = "Unlikely", Likelihood5 = "Possible", Likelihood5 = "Likely"), Consequence5 =…
-
Tracking date when a drop down value is selected
I'm creating a project tracker where I can assign what phase the project is at (design, prototype and complete). What I want to do is track how long the project is in each phase, so what I plan on doing is tracking when the drop down items are changed. I thought of using an IF statement where if "design" is selected, then…
-
Gathering data from 1000 sheets
Hello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to every corresponding line Use that number for further calculations (which is not a…
-
Automatically autopopulate a cell from a cell in the same column based off the date in its row?
I want data I enter to automatically input into my summary table if it is from the previous month. Can you automatically autopopulate a cell from a specific column into another cell based off of the date from its row? For example, can I have the Associate Healthcare number from last month automatically populate into the…