If problem

eugeniyaromanov — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone!

I have a problem I can't handle...

I need to write IF for many rows to have one row in the end

I have 2 tables:

1st Data table:

Where I can see date, time and a route.

And I have 2nd table with statuses:

Two of them is good and one is bad.

I need to understand which number is good and which is bad.

So, if all statuses are good, number is good, and if number has even 1 bad status, I need to display it as a bad number.

In the end, from this data I need table like this:

Data table:

Please see the attach with data.

Re: If problem

neelamsaroha157 — Wed, 17 May 2017 13:46:41 GMT

Check this out

eugeniyaromanov — Wed, 17 May 2017 13:50:47 GMT

Great!

How couldn't I think of this?

Thank you!