Form to filter report


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.


Best Answer

  • Markus1998
    Markus1998 ✭✭
    Answer ✓

    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.