Hello! I am new to Smartsheets and am trying to build a Summary Report based on drop down selections and data from various sheets.
I have a TON of data and too many cells so I've had to spread it out on a sheet per month. I have two drop down selections. One is to select the month and the other is to select a division within that month. I am trying to calculate/show a compliance rate for specific elements based upon the month and division that could be selected.
Is there a way pull the data pulled from a specific sheet based upon what is selected from the drop downs?
