-
Count Formula
Hello, I am working on the below formula and I am not sure if it is even possible to combine the two. I am wanting (in the Health column) to count if there are more than three red health subtasks, to show as red, if there are more than 3 yellow, to show as yellow, and anything else to be green. I would also like it to show…
-
Why isn't this simple formula working?
Hi, I am trying to add 3 columns together in one column. Each of the three columns below are populated by other formulas. All of the formulas below return an #UNPARSEABLE error =COUNT([# OF DETECTNET REQUESTS OPEN (AWAITING DECISION)]@row + [# OF DETECTNET REQUESTS PENDING (CREDIT APPROVED)]@row + [# OF DETECTNET REQUESTS…
-
How to specify a row has a specific parent in a function
I'm trying to average a collection of rows that fit a certain criteria. So far, I have this formula and I know it works up until Job@row. =AVG(COLLECT({DurationCPT},{CPTQ}, Job@row,{Packaging JobCPT},(PARENT("CMO")="Packaging Summary"))) For the rest of the formula, I am trying to full specific CMO rows that have…
-
Conditional Formatting Based on another Cell in the Row (Lab Specs)
Hello! I am looking for a way to make the lab result column values red if they are over the value found in the spec column. There are multiple fabrics each with different spec. They are all being tested in the same manner with the results in a singular column. A VLOOKUP pulls in the spec based on fabric chosen in fabric…
-
Academic Calendar: How to automate dates using days of the week
Hello everyone! I'm trying to get automatically the dates for each lesson, based on the first class (orientation). Days of the week are fixed. Is there a way to calculate all dates for classes and AWs based on the Orientation Date? Thank you very much in advance!
-
Extract text from cell string using delimiters "/" into separated columns
Hi all, I've been fiddling with this for some time. I need to extract the text between the two / / In this case, it should return "PPA." I've explored a solution using the following post, but I can't seem to achieve success. Any suggestions? Extract text from Cell String using delimiters “|” into separated columns —…
-
Summary across sheets
I have two work plans with folks assigned to tasks and want to be able to see how many tasks on each sheet the person has assigned to them. For example (not in terms of formatting) Person A: Sheet X=# | Sheet Y =# Person B: Sheet X=# | Sheet Y =# I have a report grouped by person that has both sheets feeding into it but…
-
Formula to change status based on sheet value
I'm trying to change a status (from a dropdown box in sheet summary, based on a date field. When a check box checked the status would change. Sheet Summary Field is "Construction Status", drop down list is: Not Started Permitting In Progress Permitted Inventory Slab Starts In Progress Slab Starts Inventory Vertical…
-
How to make parents equal to the children list in a drop down menu
Hi everyone, I have been struggling for a while with this formula. I'm trying to have the parents populated automatically to be equal to the list of children in a drop down menu, without repetition if the same instance is repeated twice in the children. In the picture below I'm trying with =JOIN(DISTINCT(CHILDREN()), " ").…
-
sheet summary report not counting multiple different responses given in one cell
Hi all, I have a summary sheet report with fields drawing responses from surveys collected. The surveyed people were able to tick several possible answers in the surveys. These multiple responses appear in one cell, e.g. "how did you find the event?" and the answers are "fun, educational, accessible". I would like the…