topic Re: Schedule totals to include hidden rows in Revit Architecture Forum

Schedule totals to include hidden rows

aviv3JLEU — Tue, 28 May 2024 10:08:48 GMT

Hi,

Im working on an area schedule of an apartment building for a sales document.

I need the calculated and grand totals to include some hidden rows in the schedule that can not be visible.

Is this possible?

Re: Schedule totals to include hidden rows

barthbradley — Tue, 28 May 2024 17:43:39 GMT

What method did you use to hide certain rows?

Filtering? If so, the info is not being reported in the Schedule at all and therefore cannot be quantified. So, I guess the question is how to quantify something that is not there. Do you understand you correctly? If yes, that's a real brain-twister.

Re: Schedule totals to include hidden rows

ToanDN — Tue, 28 May 2024 17:46:09 GMT

Yes. Use conditional format to mask rows.

Re: Schedule totals to include hidden rows

aviv3JLEU — Wed, 29 May 2024 02:37:27 GMT

Thanks for the Help.

I tried to read up and play around with conditional Formatting to mask the row but couldn't get it to work.

could you explain how this should be done.

Re: Schedule totals to include hidden rows

barthbradley — Wed, 29 May 2024 03:31:51 GMT

You can black it out.

Re: Schedule totals to include hidden rows

ToanDN — Wed, 29 May 2024 03:42:47 GMT

Here is an example to mask the cell with MARK = E2.1. You would repeat the same condition format for other columns to mask the entire row.

I understand that it is not very intuitive and very time consuming. Another way is using a masking region to cover part of the schedule on sheet.

Re: Schedule totals to include hidden rows

aviv3JLEU — Wed, 29 May 2024 05:20:04 GMT

Managed to get it to work.

Easiest way, i think would be to use a masking region on the sheet as mentioned.

Thank you both again for the help.