-
INDEX & MATCH Columns
Hi, I tried to Index & Match 15 columns in a New sheet with the existing Master sheet. However, it only allowed 10 columns only - attached below message. Please advise. Thank you.
-
Multiple IF/OR Formula Question
Hi All! I can't seem to get this formula figured out for what I need it to do. I believe it's a combination of =IF and =OR but haven't been able to figure it out. What I'd like is for the Aggregate Column to read any of the names of the games if the date in the column that precedes it is 9/2/23. For example, in line one,…
-
Formula or Automation for when Parent row is checked, automatically checks children rows??
Hi team, I have been struggling to work out if there is a formula or an automation for when I tick a parent row, can the indented (or children rows) also be automatically ticked? Alternatively, is there a way to prevent automation to send emails if a children column is ticked and only work for the parent columns? See below…
-
Sumif
Hello I'm rubbish with formulas! I know what I want to achieve, but even reading explanations confuses me! I have a column which has a load of numbers against each row, e.g. 3,345, 8,451 etc and I have a column of 'feeds enabled' with yes no responses. Therefore in my summary I want a total count which is for all the rows…
-
Formula to count based on 2 conditions (Check boxes sheet)
I have a sheet that has a few check columns. I need a formula that will calculate 2 conditions: checked in a certain column but also submitted in the same row. Meaning I need a count of only the ‘Other’ that were ‘Submitted’ (it will be only 1 on the example below). Here is a few formulas I have created:…
-
Workflow message image not coming through
I have a workflow set up within my sheet. It is triggering and working correctly, however the email message that I receive has a missing image. I imagine that our email security scanner is stripping out the image as it is coming from an external party. Is there a way to remove it alltogether?
-
Check inventory in two columns and change symbol column.
Hello all ! I have a challenge for you guys. I have a sheet where we book groups for a venue. Some of those groups will also book a space for a cocktail before the show. There are 3 spots available per day for a cocktail. I would like to have a column that tells me if the cocktail area is available for that date. I guess I…
-
Counting blank cells when other criteria is met
Hi, I need to add on top of a formula that counts tasks that are in progress or not started that are past due. The formula below works for that, but now I also need my total to include cells in the target completion date that are blank. =COUNTIFS(Status129:Status144, OR(@cell = "In Progress", @cell = "Not Started"),…
-
Averaging a column based on an IF formula
I have a column with an IF formula looking at a form input of yes/no. If yes, it generates a 5, and if no, it generates a 1. I am trying to average this column in another sheet but keep getting a: #DIVIDE BY ZERO error. I have ensured that I have no error messages in the original column. I've tried other averages off the…
-
Stuck on a cross-sheet formula for overdue items
Hi, I need to create a stacked bar chart with how many items are due a month ( I have gotten that formula) by doing =(COUNTIFS({ Range 1}, >=DATE(2022, 1, 1), {Range 1}, <=DATE(2022, 1, 31)) + the preceding 5 sheets. I also have added how many are completed on time, how many are not. However I also need to do how many are…
