yep, this is wheelhouse stuff for Glide.
As you learn more about Glide computed columns you’ll find that there are many things that are easily done in Glide that would previously have required Spreadsheet formulas.
he he he True that. I had spent quite a lot of time trying to figure this out in the first few days and then moved back to trying with formulas and that was not a jolly ride either. But closed the sheet and came back with a open fresh mind and could do this in 3 clicks in Glide table.
These are the times when i feel SQL and writing queries is much easier.