Vlookup help

Chris Pallatto
edited 08/03/22 in Formulas and Functions

Good morning,

I've tried to create a countif & vlookup formula without luck. I would appreciate any help!

I have linked the attendance sheets from several committees into one sheet. I would like to sum how many committees each organization is participating in (participation and return that value in the "# Committees Participating" next to each organization's name.

I'm stuck and would appreciate any help!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!