-
Countifs no longer working
Hello, I have a countifs formula that was working and is no longer... This is for my "metrics" sheet so the information is being pulled from the Garage Access Issues Log onto another sheet so I can use it in a Dashboard. I'm trying to count how many issues are showing as unresolved and not archived. Both the 'Resolved' and…
-
Nested IF CONTAINS, Return Blank When Contains Blank
I've searched the Community and haven't found this situation, so I appreciate any help. I have a data set in which I'm trying to write a nested IF CONTAINS formula to return the primary program based on what is contained in the Project ID field. My current formula is =IF(CONTAINS("ABC", [Project ID]:[Project ID}), "ABC",…
-
IF Formula
Hi everyone. Im stuck with a formula and need help. this is a screensot of the sheet im working on. I have a formula in the APP STATUS column. it basically returns the status to show if all items of an application is processed (complete). here is the working formula i have: =IF(AND([Profile Picture]@row = "Complete",…
-
How do I combine multiple INDEX Collect formulas in one Formular?
Hello, dear support team, I have a question about combining several Index Collect functions. The Goal is: I want to get the Payment Terms into the Cash Out section of the Cashflow. As you can see in the picture below; 25% of Product #1 has to be paid in the calendar week 8. 50% of P#1 in CW9 and the remaining 25% in CW10.…
-
Embedding a linked file on a row as a link in a column
Hi all. I was wondering if any of you have found a way to actually automatize the creation of a link based on a file linked to a row. It is probably not even needed to create a link, but to use an IF statement that checks whether the row has some attachment or not (if we can show in a report that there is an attachment…
-
Multiple Contact Cell in a COUNTIFS statement to only extract one name
Hi all. I have been browsing the community for some time, but have been unable to find a solution to this issue. I have been trying to count a specific name from a multiple contact column, but calculations are not capturing the right number. I have tried two different approaches: {E2E Framework Solutions Funnel Range 21},…
-
Sheet Summary Formula
Ok I have 3 sheet summary formulas that I am trying to make into 1 formula - is this possible? =COUNTIFS([ESG Core - 4 units to pass]:[ESG Core - 4 units to pass], >=4, [Start date]:[Start date], <TODAY(-180)) =COUNTIF([Start date]:[Start date], <TODAY(-180)) =SUM(ESG# / [ESG %]#) * 100 It works as 3 but would look tidier…
-
Using IF and unchange the cell value if it happens to be false.
I have this worksheet Column B is a drop list of variables - "Completed", "In Progress", "Enrolled", etc. Column C is Date Completed (meaning if the learner completed the course, we stamped the date when this learner completed the course. So when I input in the date, I would like. Column B to change to Completed form…
-
Assigning Unique Numbers To Duplicate Values
Hi, I'm trying to find out if there is a way to label each duplicate in a column with a unique sequential number that count each set of duplicates like in the below pic. So, if John was listed 4 times in a column and Abe was listed 7 times, John would be numbered 1-4 and Abe would be numbered 1-7, etc. Any assistance would…
-
How can I create a formula to count occurrences with THREE different value criteria.
I am trying to create a formula that will pull a count of occurrences with 3 specific values. I currently have a main sheet that is capturing a Child Care Center's student spaces by age and if the space is "Filled or Vacant." Screen capture of master sheet to source data for metrics sheet: I then created a metrics sheet to…
