Increase the value based on checkbox

PYI

Hallo all,

• column Team has different types of values (Requirement, Infrastructure, Developemnt....)
• column Active will represent whether they active in project or not

Problem:

~ If i select Active column checkbox for any member then Active Help column should show their team name and count for ex. Requirement Team 1,

if i select Active for another person from same team then Active help column should show ex. Requirement member 2

I need some assistance, can anyone pls help me out

PYI

Hi ,,, Is thr any possibilities,,,,

Thank you for your help,

Paul Newcome

Insert an auto-number column with no special formatting. Then the formula in the Active Help column would be

=Team@row + " Member " + COUNTIFS([Auto Number Column]:[Auto Number Column], @cell <= [Auto Number Column]@row, Team:Team, @cell = Team@row, Active:Active, @cell = 1)