-
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…
-
Need Help w/ Counting Week of
I am trying to count how many items on the list have a scheduled pickup date for this week. I already created a week number column. Here is the formula I am currently using but I keep getting an error message. What am I missing?