Counting series (for example: Winning Streak)

Hello,

is it possible to track a Winning streak? And do you know how?

For example
Cell Win increments +1 –> Cell Series should also increment +1 -> If Cell Lose increments +1 the Cell Series should be reset to 0. How can I safe the highest value of the cell (best Winning streak)?

Do you have a better logical process? And is it posible with airtable?

Thanks and best regards!

solved - please close this ticket

Hey Louis, Out of interest, how did you go about solving this?