Conditional format for groups

1

Hi there,

is it possible to apply a conditional format rule onto a group?

Greetings

2

Can you explain more what you mean?

When I really need some sort of conditional formatting in a group, I concatenate a rectangle().clipCircle() onto a value and get a display like this:

image
image1450Ă—632 29.8 KB

If you give more info on your context or ask im sure I can assist!

1 Like
3

Hey Scott,

thanks for your answer. I was trying to strike through a group if all sub-tasks of that group are done:

image
image1636Ă—1119 101 KB

The conditional formating only works if I ungroup the tasks.

4

You will need to put the conditional formatting rule on the Task table where Task 1 is from. The formula for the rule would look something like:
thisRow.Subtasks.CountIf(Not(Done)) = 0

Then be sure to, in the configuration for column Task on Overview Tasks table, make sure that “Apply Styling” is checked (which is default).

Let me know if this doesn’t make sense to you and I’d be happy to help you know where to put these formulas.

(P.S. the reason why my solution works and yours doesn’t is because you cannot format grouped columns, but you can group by (pre)formatted values. Though I agree that it would be convenient and intuitive if you could format group columns with conditional formatting like you tried to do.)

1 Like
5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.