Does anyone know of a way to group areas when scheduling spaces? For example we would like all of the Restroom spaces to be grouped and the areas totaled as one row item in the schedule and not a line for each restroom.
|
Does anyone know of a way to group areas when scheduling spaces? For example we would like all of the Restroom spaces to be grouped and the areas totaled as one row item in the schedule and not a line for each restroom.
Include a quantity column in your Schedule Table. All rows that have identical information in each column will collapse into a single row, and the quantity column will indicate the number of Spaces that row covers. If you include an Area column, you can add a formula column to calculate the product of the quantity and Area columns, to get the total area of all items on that row. You can hide the quantity and Area columns if you do not want to see them.
All columns must have completely identical data. So you will not be able to include room numbers in your schedule (assuming you assign unique numbers to each room). Also be aware that the comparison of data is based on the raw value, not the formatted data displayed in the schedule table. So if you round the Area value to the nearest square foot, and have two Spaces, of 100.2 and 99.7 square feet, both will display as 100 square feet, but the rows will not collapse. You can use a formula property to get the raw value to be the rounded value. You can read more about this technique in this blog article, if you are interested.