Skip to main content

Hey Hey

I want to apply conditional formatting on shapes which are grouped with another shape. For this I started creating a rule with custom formula and expected this to work

```

=SOME(Groups, x => CONTAINS(x.items, THIS."id"))

```

But unfortunately this doesn’t. Any idea what’s wrong?

Hi @tobi 

The conditional formatting doesn't support complex formulas or functions like SOME() or CONTAINS() si what i sense - in the way you've written them.

Can you try the below:

=COUNT(GROUPS()) > 0

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards

 

Thanks @Humas1985  for this quick answer. You suggestion sounds helpful, although my lucid doesn’t know anything about the `GROUPS()` function. Anything else I can try?

 

 

Hi @tobi - Thanks for trying that, realizing that the conditional formatting engine does not support the GROUPS() function also, the COUNT() function is limited to ranges or lists, and group memberships are not exposed as a list or countable property within this context.

Let me try it from my end to see whether i can spot a possible workaround from my end.

Regards

Hi!

 

I think you can try this:

 

=shapetype(parent) = “Group”

 

 

Reply


Lucid Software Inc. Supplemental Community Terms