Is there a way to take the average of the RYG colors and roll it up to an overall summary for a section and then the overall section to the overall project summary? I've included a snapshot of what I'm talking about.
Hi Frank,
Yes, it is. You'd need to decide on the rules for when it should be R,, Y or G.
What are your criteria?
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
The end users decided an selects based on the task if it is red-at risk, green - on track, yellow in between on track and at risk. Some fields might be blank if it is not filled in but we would like to take the average of the colors and assign the overall status. I hope this makes sense.
Try something like this.
Add the formula to all parents in the status column.
=IF(AND(COUNTIF(CHILDREN(); "Green") > COUNTIF(CHILDREN(); "Yellow"); COUNTIF(CHILDREN(); "Green") > COUNTIF(CHILDREN(); "Red")); "Green"; IF(AND(COUNTIF(CHILDREN(); "Red") > COUNTIF(CHILDREN(); "Green"); COUNTIF(CHILDREN(); "Red") > COUNTIF(CHILDREN(); "Yellow")); "Red"; "Yellow"))
The same version but with the below changes for your and others convenience.
=IF(AND(COUNTIF(CHILDREN(), "Green") > COUNTIF(CHILDREN(), "Yellow"), COUNTIF(CHILDREN(), "Green") > COUNTIF(CHILDREN(), "Red")), "Green", IF(AND(COUNTIF(CHILDREN(), "Red") > COUNTIF(CHILDREN(), "Green"), COUNTIF(CHILDREN(), "Red") > COUNTIF(CHILDREN(), "Yellow")), "Red", "Yellow"))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Would that work?
Andrée
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…