-
If formula for RGYB balls
Hi All, I want to create a column so when i change the colour of the ball it changes to a set word. So Green will say "install" for column 7 Red will say "work needed" for column 7 Yellow will say "At VC" for column 7 Blue will say "Back from VC" in column
-
Column Reference Formula Returning Incorrect Answer
I am writing a simple COUNTIFS formula and I am getting a very different answer when I created a column reference vs. referencing a specific range within the column. What am I missing? I am trying to count the number of customers that are not installed or closed to determine how many are "in process". This formula which…
-
Copy INDEX formula down for the rest of the column
Hi all, I want to autopopulate the first column of sheet B with the data from the first column in Sheet A I got it to a point with using the INDEX formula to reference, but now I cannot drag the formula down to apply this for the entire column. This is for row 1 "=INDEX({Sheet A MUR TN}, 1, 1)" I think I am missing…
-
Counting Checkboxes in a row and then showing the average %
I am trying to find the average of checkboxes in a row. At row: "Clear pads as needed..." I want the % to add up as each box is checked. What is the formula? Appreciate the help.
-
SUMIF formula when cell contains multiple collaborators
I currently have a formula that will sum up the "Hours Used" from the "proposed hours needed" field based on which intern is assigned. =SUMIF(Intern:Intern, "Michelle", [Proposed Hours Needed]:[Proposed Hours Needed]) However, when BOTH interns are assigned, it doesn't acknowledge the hours - how can I update my formula to…
-
Count IF on System-Generated Column
Is there any reason why this formula would be totaling a different number than what I am seeing here? I am counting 17, however, the formula keeps returning 30. I am counting 17, however, the formula keeps returning 30.
-
Use SUMIFs and ISDATE to sum based on dates within the past week
Hello, I'm attempting to use SUMIFs to sum one column based on whether another column has dates within the past 7 days. However, my current formula is unpareseable. All help is appreciated! =SUMIFS([No if Sites]:[No of Sites], [Payments Closed Won Date]:[Payments Closed Won Date], ISDATE(TODAY()-7)) I have seen posted…
-
Apostrophe added to formula that is pushed from Zapier
We’re using a sheet for ticket tracking. Issues come in via a form, manual entry, or the Gmail Add-on. We’re using hierarchies to track To Dos as tasks. I use a simple formula to tell me if a row is a task or a parent. =COUNT(ANCESTORS()) I use the value for formatting and for accurate issue counts as I only want to count…
-
COUNTIF(CHILDREN() Formula Assistance
The following works for my sheet but I'm unsure how to write it so that if there are no child rows, it will say "No Submission Received". =IF(COUNTIF(CHILDREN(), OR(@cell = "Facilities Readiness", @cell = "Workspace Navigation and Signage")) = 2, "Final Approved", "Partially Approved") Appreciate any assistance! Thanks!
-
Counting Number of Date Instances
Hello, I'm trying to create a formula to count the number of instances of a particular date - but I can't get a response out of the forumla - it either comes back as unparseable, or with a 0 count (even though that's the wrong count). I've tried a few variations: =COUNTIF(DATE:DATE,06/10/2020)…