-
Formula Using IFS, Contains, and AND
I am trying to troubleshoot the following formula: =IFS((CONTAINS("Shadow", {GI Clinic 3 Session})), AND([Provider Last Name]3), "Scheduled") Logic: If the cross-referenced sheet (GI Clinic 3 Session) contains the word "Shadow" and the Provider Last Name is the name in cell 3 (current sheet), then say "Scheduled."…
-
Getting #INVALID DATA TYPE using IF(AND and IF(OR together
=IF(AND([Logo Attached]3 = 1, [Lobby Sign]3 = 1, [Column Sign]3 = 1, Mailbox3 = 1, "Green"), IF(OR([Logo Attached]3 = 1, [Lobby Sign]3 = 1, [Column Sign]3 = 1, Mailbox3 = 1), "Yellow", "Red")) Formula above. Would like to display green ball when all checked, Yellow when some checked, Red if none checked. Can't figure out…
-
Sumif from multiple sheets
I need help with a formula for 2 scenarios: 1) I want to sum up the total of items from the "ATL Tasks/Notes" sheet that have any priority designation (high, medium or low). 2) Then I also want to sum up the total of items between multiple sheets "SHEET NAME Tasks/Notes" that are high priority.
-
Calculation in column is not auto-populating
I have a spreadsheet with a calculated column (If statement based on previous column). I regularly paste in new rows, but the calculated columns do not always auto-populate. When I hover over the calculated cell, the calculations are present, but they are not calculating unless I select the cell. Is there a reason for this…
-
Averageif without maximum payment
Hallo, I want to calculate the average damage without considering the maximum damage. I tried this: =AVERAGEIF(Zahlung4:Zahlung140; >1) - MAX(Zahlung4:Zahlung140) but it doesn´t work. I get a - value Any idea ? 🙄
-
Help with a Countifs formula with conditions
We have a sheet that holds information populated by a form. The form allows people to request the data team create a report for them. Sometimes the requests are actually looking for a report that would be regenerated every month. The initial request auto populates a report "DR" number in column 1. If the report is to be…
-
Adding a number of months to a date using formulas
I have a calibration sheet that lists the number of months required between calibration dates and a column that states when the last calibration was carried out. I would like to use these 2 columns to calculate the date when the equipment next requires calibration. Can anyone help? Thanks, Colin
-
Forumula for trending up/down
Hello, I need a formula to display the trend of a number. As rows (data) comes in the average value of the column changes and as time goes by the values will go down. I need to compare that average value each day. Meaning if today's average is 5.10 and tomorrows average is 5.50, I need to compare those two numbers to…
-
Help with Health Column
Hello, I need help creating a formula for the health column. Here is what im trying to do: If due date is 2 days or more away: Green =IF([Due Date]@row > TODAY(1), "Green") If due date is day before or day of: Yellow =IF(OR([Due Date]@row =TODAY(), [Due Date]@row = TODAY(1)), "Yellow") If due date is past due: Red =IF([Due…
-
Equation help
Hi all, I'm not very privy with formulas, but am attempting to learn. I'm working on keeping track of square footage production based on "in progress" or "completed" in a manufacturing setting. There are 6 different steps to each unit produced (on different lines, see screen shot), and I'm trying to figure out a way to…