Google Sheets Project Gallery

For this project, I have created a table report-generating tab based on the available ticked checkboxes. This solution has made the tab to generate tables that can change the number of columns, aside from the usual row propagation. 

It utilizes the Query function similar to SQL.

A sample report generated with the same data but with different checkboxes ticked

Daily Summary tab

I have used arrayformula function to ensure all equations are located only in row 2. Ensures easy troubleshooting and less prone to unintentional human errors.

This is a good example of project where complex computations and logic equations were used.