calculate % of average attendance
Hello,
I need to calculate % of average attendance across multiple people and events.
for example, I'm either calculating or linking from another sheet the number for the formula and have
Column 1: 49 (the # of people  might change  this is a dynamic # from another sheet)
Column 2: 8 (the # of events that already happened  will change when new events are scheduled. Dynamic # from a formula from another sheet)
Column 3:
Row 1: Total check ins: 78 (dynamic # calculated across all the events)
Row 2: Attendance InPerson: 37 (dynamic # calculated across all the events)
Row 3: Attendance on Zoom: 33 (dynamic # calculated across all the events)
How can i calculate a percentage of the total # of people for each row across all events?
Thank you!
Best Answer

@OshaK Can you share a screen shot? I am a little confused about your explanation... Can you also define what the columns are? Like Column 1, what do you mean the # of people? That signed up? That attended? 1 event? Total? Same as Column 2. Also, what are you trying to actually calculate? There are so many different ways you can run numbers, that you need to be explicit about what you are actually asking about.
Answers

@OshaK Can you share a screen shot? I am a little confused about your explanation... Can you also define what the columns are? Like Column 1, what do you mean the # of people? That signed up? That attended? 1 event? Total? Same as Column 2. Also, what are you trying to actually calculate? There are so many different ways you can run numbers, that you need to be explicit about what you are actually asking about.

thank you @Eric Law, I think i figured it out.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!