Help

Coloring the cell in the desired color when the conditions are met

Topic Labels: Automations Formulas
Solved
Jump to Solution
152 1
cancel
Showing results for 
Search instead for 
Did you mean: 
flavich
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello!

I would like your help to solve the following problem:

We conducted a survey where people answered questions and received points. Now we need to filter the score value by color
There are 3 colors for cells, which are colored when the following conditions match:
Red: if a person scored a low number of points in 4 categories
Yellow: if there are no red blocks out of 4 and less than 3 green blocks
Green: There are no red blocks, more than two blocks are green out of 4

Points: red if scored from 0 to 11 points in each category
yellow if from 11 to 17 points
green if from 17 to 25 points

How can automation be assembled so that colors are assigned automatically based on these formulas? Conditions in coloring are not suitable, since it only looks at 1 condition\

Thank you very much in advance for your help

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

I think you're going to need a formula field that calculates the number of each color there are for that record:

Screenshot 2024-07-03 at 9.46.03 PM.png

And you could then use those formula fields in your color conditioning

Link to base

See Solution in Thread

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

I think you're going to need a formula field that calculates the number of each color there are for that record:

Screenshot 2024-07-03 at 9.46.03 PM.png

And you could then use those formula fields in your color conditioning

Link to base