Count formula returning specific information
I'm working with one sheet doing a count of any openings I have in my courses. I'm trying to create a quick visual on my dashboard, but realize I must first create the formula. So I have a sheet called Counts and it is currently set up to pull back the data for Open TA slots, Cap, and Filled columns.
I would like to have the Fall or Spring column fill in with the # that matches based on my Active TAships Sheet.
I have to adhere to strict budgets, so if there is a cap of 3 for a specific course, I need to be sure there's a hard stop in place to prevent oversubscribing.
Any thoughts? Thanks so much!
Help Article Resources
Check out the Formula Handbook template!