What's the best way to add specific cells depending on which checkbox is checked, without a super long nested IF statement?
I'm trying to put together some basic scheduling spreadsheets for my lab techs where we want to show 6-months at once so we can forecast out, but also only want to display the hours for the active week. I've currently got it setup where we can see all weeks at once, with a checkbox labelled "Active Week", and am trying to input a formula where the total hours displayed will only calculate based on which week is active.
For example in the screenshot, I want to see the physical schedule for weeks 1-3 but if I click on the Active Week checkbox for week 2, for example, I only want to see the total hours for week 2 (Mon-Sun) in the lefthand column.
The only way I can fire out to do this is a nested IF statement, but with 26 weeks, thats going to be a hell of a long formula. Is there an easier way to do this using filter or lookup commands?
[link] [comments]
Want to read more?
Check out the full article on the original site