Nabeel_Hyatt - profile

Nabeel_Hyatt · Apr 30, 2018

I’ve tried a bunch of formulas and various table structures and just can’t seem to find a way to get what I need. So let’s say I’m running a kids soccer league, or an e-sport, or really anything close. In other words I have games: Celtics Win - Pacer...

Nabeel_Hyatt · Jun 06, 2018

This is amazing. I mean, it’s obviously a kludge and I wish Airtable supported it more natively, but you’ve definitely solved the problem!

Nabeel_Hyatt · May 10, 2018

Hah. And yes, I definitely know how to do this in excel with a very long IF statement. In case it gets your brain firing here’s my statement in excel right now (though it does this and a whole lot more). =IF(’#Matchups (St)’!G9="","",IF(AND(‘Total Ma...

Nabeel_Hyatt · May 09, 2018

Just for explorations sake, how would you do it explicitly? Generally of course I’m not looking to generate the result once, but in a formulaic way so you can work your way through all the matchups. If there’s a manual way to do it then, theoreticall...

Nabeel_Hyatt · May 08, 2018

yeah you are right, it’s pulling the data you would want, just in an incredibly hard to digest format. The database function would just be allowing you to reference a count against a combination of elements, instead of a single element (if “team a” a...

Nabeel_Hyatt · May 08, 2018

Pivot Table blocks are getting closer to what I need, for sure. They can’t really display the necessary information though. The default is Count - which would just be the number of games played, not the W/L record. There’s no way to reference the Piv...

User Statistics

User Activity

Conditional Counting if Multiple Conditions Met

Re: Conditional Counting if Multiple Conditions Met

Re: Conditional Counting if Multiple Conditions Met

Re: Conditional Counting if Multiple Conditions Met

Re: Conditional Counting if Multiple Conditions Met

Re: Conditional Counting if Multiple Conditions Met