Applying a formula when a filter is applied
Hi! I am building a team monthly capacity tracker. Right now, it's all in one sheet and I have filters set up based on the 'Owner' column, so each team member can view and update only their projects and activities. I have a formula summing up team capacity each month at the bottom of the sheet. Is there a way to carry over the formula to when a filter is applied, so that each team member can see just their capacity each month, when they are updating the sheet? Do I need to create a sheet summary or report, or is this possible just in one sheet? Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!