Form to filter report

Markus1998

I have a SmartSheet Form collecting information for room areas for different building types. Can I have a checkbox for each room? If the box is checked, the Recap Report will include it in the room area calculation.

Markus1998

I resolved this by creating a yes/no column for each room type in item 2. Database (Smartsheet). Each of the individual Smartsheets for item 4. BoD Formulas, calculate a zero for each room (row) if the column above is no.

Andrée Starå

Hi @Markus1998

I hope you're well and safe!

Where do you do the Room area calculation?

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Markus1998

Hi Andree, the room areas are calculated in step 4 Basis of Design Calculations. Each country has a separate BoD Smartsheet with the area calculations for about 100+ rooms. These SmartSheets reference inputs in step 3. Inputs.

Markus1998

I resolved this by creating a yes/no column for each room type in item 2. Database (Smartsheet). Each of the individual Smartsheets for item 4. BoD Formulas, calculate a zero for each room (row) if the column above is no.