Tracking Space with Nested AND/OR statement?

Options

I am trying to track the amount of space (square footage) that multiple projects use within my greenhouse and have been able to do this down to the month. However, I running into issues on tracking space down the individual days within the month. My current formula for space by month (using June as an example) is:

=SUMIFS($[Project Volume]:$[Project Volume], $[Start Month]:$[Start Month], <=6, $[End Month]:$[End Month],

I am not sure how to track the changes within the specific month though. I suspect there are some nested OR and/or OR statements needed but can't get them to work. The example below (shows updateed volume info for June 1) gives the response "#Inlavid Data Type."

=SUMIFS($[Project Volume]:$[Project Volume], $[Start Month]:$[Start Month], <=6, $[End Month]:$[End Month], OR(AND($[Month End]:$[Month End],6, $[Day End]:$[Day End],1)))

Any thoughts on how this can work?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!