Color records linked with a record of "special kind"

Either a rollup field or a formula field (or two) could easily accomplish this.

• General Basics

TBH this use case sounds simple enough that someone might have already written what you needed if you at least shared a screenshot, aaa-bbb abstractions are just another obstacle to the mind after a long day. :grinning_face_with_sweat:

See, an image is worth a thousand words, and I have a couple of them for you:
My crude recreation of your base description amid some other random base, the key fields are the linked resources and the rolloup listing their props:

There are many ways to fine-tune its output, but here’s a super-simple one:

You can then filter the results by thos which include a comma, which automatically means it contains more than one of your selected match:

And/or you could use that logic as a basis for a standalone view filter:

Hopefully this proves illuminating but let me know if I misunderstood or you’re still having issues.

Oh this is great. Amazing!

Worked like a charm. I even used ARRAYUNIQUE(values) on the aggregation of the rollup to have resources only once in there. This works great and I can live with that for now.

Nevertheless let’s level up one more complication as I’m challenging myself with this:

I do have on projects two fields where I assign these resources. One column called “resource assigned” the other one called “resource backup”. Now I want to do the coloring based on when NONE of the two fields has any resource of prop “bbb”.

Can you follow? It’s like a rollup looking in two fields on a record. I guess I would need to summarize first and then do the lookup/rollup, right? Would that be easier to do with a formula or how would you approach this?

My current approach is to do two rollups and combine them it on the coloring conditions. Do you see another approach to the problem?

Oh this is great. Amazing!

Worked like a charm. I even used ARRAYUNIQUE(values) on the aggregation of the rollup to have resources only once in there. This works great and I can live with that for now.

Nevertheless let’s level up one more complication as I’m challenging myself with this:

I do have on projects two fields where I assign these resources. One column called “resource assigned” the other one called “resource backup”. Now I want to do the coloring based on when NONE of the two fields has any resource of prop “bbb”.

Can you follow? It’s like a rollup looking in two fields on a record. I guess I would need to summarize first and then do the lookup/rollup, right? Would that be easier to do with a formula or how would you approach this?

My current approach is to do two rollups and combine them it on the coloring conditions. Do you see another approach to the problem?

Another rolloup array or lookup reference would allow you to do so, so would a custom view and dozens of formula combinations. Personally, I’d probably just go with regex here as direct, no-nonsense queries are what it’s good for:

So, see what this does:

REGEX_MATCH(
    {ResourceAssignedColumnName} 
& "" & {ResourceBackupColumnName},"(bbb)")

It should return a 1 if there’s a bbb somewhere in there and 0 otherwise.

And note that you can replace the “(bbb)” part with another field reference in the vein of “(” & DesiredFieldName & “)”, depending on whether you’re going for full auto or are simply building a dashboard of sorts and would prefer to have some agency without redoing the formulae every now and then.

I tried a bit and found that it works when the resource name has a “bbb” in it. But as it’s an attribute to the linked record I’m not sure how I can tell the Regex that it should look into the details of a record to match against.

Example: The linked resource name is “Ford Mustang”, but I want to match against the property “e-powered” of the Ford Mustang.

• General Basics

TBH this use case sounds simple enough that someone might have already written what you needed if you at least shared a screenshot, aaa-bbb abstractions are just another obstacle to the mind after a long day. :grinning_face_with_sweat:

See, an image is worth a thousand words, and I have a couple of them for you:
My crude recreation of your base description amid some other random base, the key fields are the linked resources and the rolloup listing their props:

There are many ways to fine-tune its output, but here’s a super-simple one:

You can then filter the results by thos which include a comma, which automatically means it contains more than one of your selected match:

And/or you could use that logic as a basis for a standalone view filter:

Hopefully this proves illuminating but let me know if I misunderstood or you’re still having issues.

If I got that right, can’t you just add that condition over here:

If not, duplicate the field, just switch the conditions.

Oh yes, I’ve had that solution already. This rollup works looking on one field, but not two.

Look here: This is the solution you propose. The rollup is looking into the Primary Resource and rolls up when there is a link with prop powered electric.

The challenge now is to look in Primary and Backup Resource at the same time for a prop electric linked record. Here is an example. Find the “VW ID3” in both resource links.

I’m wondering if there is a solution using a formula?

I tried the “REGEX solution”, as you can see in the column left to the rollup. I can only make it work with a REGEX matching for “VW” here, but not the prop of the resource “electric” which would make it work for all resources regardless of a naming convention.