-
JOIN COLLECT DISTINCT CHILDREN FROM ANOTHER COLUMN WHERE CHILDREN OF CURRENT IS TICKED
I have two columns. primary and column B On the parent row for column B, I want to look at any children which are ticked and then join collect distinct values from primary column. If I was to do a basic formula in column B it would be this for children: =JOIN(DISTINCT(COLLECT(CHILDREN(), CHILDREN(), <>"")), CHAR(10)) I…
-
Interest Calculation based on multiple column
I am attempting to calculate interest based on a past due value in one of 4 columns. I need this formula to calculate all 4 columns because the amount may appear in one column this week and move to another the following week. I am able to get it to calculate using one column but when i attempt to add more columns i get an…
-
Need help on Countif with OR & AND in report filter
I have following screenshot's report, but I couldn't figure out in formula using Countif formula, I tried with below formula: =COUNTIFS({ProjectSurveyContact1}, OR(HAS(@cell, "")), {ProjectSurveyContact2}, OR(HAS(@cell, "")), {ProjectSurveyContact3}, OR(HAS(@cell, "")), {ProjectStatus}, OR(@cell = "Closed", @cell =…
-
Incorrect WeekNumber or(??) Year when trying to return a 'Week Number of Year' calculation
I am trying to return "Week Number of Year" (I want two digits for the Week Number hence the workaround in the formula) and all my weeks start on a Monday. I have used the following formula which works great until you get to Monday 30 Dec 2024 where it returns "01 of 2024" - clearly wrong as Monday 01 Jan 2024 should be…
-
Can I put a max on a sign-up time slot on a form?
I am creating a sign-up sheet and am providing 3 signup times for people to choose from. I need each sign-up time to have a max of 15 people who can choose this time, is this possible? If so, how?
-
Formula to subtract one month from a date
Hello. I need to subtract one month from a date. I have tried =Date-30, and then minus 60, etc. By month minus 5, I was quite a bit off from the first of the month. If the Date being evaluated is say 4/1/20, I'd like the first calculation to produce 3/1/20, and the next row to produce 2/1/20, and so on. I did find a…
-
Due Date Formula
Someone recently plugged a formula, =MIN(CHILDREN), into the due date column of the sheet I maintain, which is causing the parent rows to have an incorrect, past-due due date. I deleted the formula and replaced it with the correct due date, but it seems the sheet automatically reverts back to the formula due dates. The…
-
Need Formula Help: How to count multiple drop down values?
Problem Statement: I have a sheet that was used in a form with multiple drop down selections and need to discover how to calculate total selected by category. Need to count how many times apples was selected. Example of column sheet: Column Choices: apples, grapes, oranges, other I have tried using the COUNTM formula and I…
-
Display Chart for Multiple Groups in Report
I am hoping for some help. I currently have a report created that is grouped and counting what I need. The goal is to count how many bugs and enhancements there are per category. I want to be able to create a double bar graph off these counts but not able to get the chart to display how I want. My report looks like the…
-
Is there a formula to have two months shown in one cell?
For instance, the image below shows Mar in the first cell, and in cells 4 to 10 shows March going into April. Now in the first cell I would like for it to show Mar - Apr Let me know if thats possible. Thank you, Jeff