-
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?
-
Date Calculation not working correctly
In my Operating Calendar sheet, I have a Due column (date). This due date column should be calculating based on a formula that adds the "Days From Pricing Group OR 1st Departure Date" column to the "Pricing Group Date" Column (=[Pricing Group Date]@row + [Days From Pricing Group OR 1st Departure Date]@row). Both the "Days…
-
How to find the Nth weekday of a given month?
I'm working on a formula that will provide the date of the 3rd Thursday of the month. That much I have working, but am trying to modify it to work for any weekday of any month. As of now the first and last weeks of the month are causing issues (returning a date from previous month, returning a date in the next week, etc.).…
