Increase the value based on checkbox

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!