I'm new to the community so thank you in advance for your help. I'm currently working with a client that runs its own community platform, and I've been tasked with tracking total monthly members and MoM growth for the client's various community groups on a single tab (see attached workbook for an example). This works fine until I need to add in a new community group, in which case I have to manually add a new row under the 'Total Members' section and a new row under the 'Total New Members Per Month' section, and then pull down the formulas.
Is there some way I can add a new group to the first section (Total Members), have that same group added to the second section (Total new members per month), AND have MoM growth automatically calculated for the new row in the second section?
And is there a way to have each section automatically alphabetize itself when a new group is added to the bottom?
Bookmarks