-
Performance issues
Hi All, I have 4 sheets with 5000+ rows & with 4 column formulas. I would need to add a 5th formula, which looks like as stated below. When I added it the sheet started to slow down, it was freezing, since the formula runs on the cell basis. Is there an option to optimize the sheets' performance, when cell formulas are…
-
Using the OR function within a count formula referencing another sheet
Hey all, Trying to work out how to add in the OR function to a count formual referencing another sheet. Presently I've got..... =COUNT(COLLECT({Activity}, {Row Type}, "Parent", {Status}, "Delayed")) But the Status could be any of "Delayed", "In Progress" or "Client Delay" Any help much appreciated!! Thanks, Anna
-
How to use a COUNTIFS formula that excludes multiple criterion in Multi-Select Dropdown column?
I'm trying to count the total number of values in a Multi-Select Dropdown column when criteria in another Multi-Select Dropdown column is not present. For example, let's say I have a FRUIT column with Apple, Orange, Banana, and Kiwi values. I also have a STATUS column with Rotten, Fresh, Stolen, and Eaten values. In rows…
-
Return a cell when one column matches another within an IF statement.
Morning, I've been struggling with how to return a specific value from two columns. We have created a risk register, and we want to show the overall risk rating for the project. The Overall risk is simply the risk of the highest ranked risk regardless of count. Initially, we are just using an IF statement, with a HAS on…
-
Formula to track duplicate text/values across multiple columns
Hi there, Apologies if this question has been asked multiple times but i have searched across the forums and cannot seem to find a definite answer to a problem i'm trying to find a solution for. I have built a tracker to track web activities across our site encompassing language, page that the activity occurred on along…
-
Prevent Cell Formula from being overwritten
I have a cell formula that will change the status of the parent cell (in this case Materials) to Green, when all of its children are either Green or Gray. However, since the sheet is shared amongst multiple people, it can be overwritten manually when someone changes the status to a different color then the properties of…
-
cant get IF statement to change value of another cell
I am trying to use an IF statement to change the value of "Ball in Court" based on the "PM question" cell: FYI - both "Ball in court" and "pm question" are dropdowns =IF([PM Question]@row = "02 - Changes Needed", [Ball in Court]@row = "01 - ENGINEERING", "") When I set "PM question" to "01 - Submitted" the formula doesn't…
-
RYGB symbol average Formula
Hello Everyone, I have a sheet with 13 different people filling it out with RYGB symbols. So I am having issues with creating a formula that will take an average of 13 people. Here is what I got so far and it's coming out unparseable. =IF(COUNTIF(Aaron@row, Chuck@row, Pablo@row, Lee@row, Oralia@row, Brady@row, Lowrey@row,…
-
Checkboxes to Generate List
Good evening! I need a little help to see if what I want to do is even possible. I am wanting to create a list of people based off of a response to a checkbox. For example, if someone completed a form with their name, address, and other fields to include checkboxes, and checked a box titled 6/7, I would want that person's…
-
Count of duplicates within the last 90 days
I need a formula to count the duplicate entries of 3 or more within the last 90 days. Then flag the row for a weekly report. I will group flagged row (clients) on a report. I was able to count the duplicates but need help with the formula to count if it fits the criteria of "Date Created" within the last 90 days. I have a…