You have a section in your table that needs to show a section based on a condition. You do not want to show all the rows or columns, just the ones relevant.
Rows and columns in the excel template can be hidden or deleted based on conditions. This is controlled using the comments feature in excel.
How to do it
The format of the comments needs to be “VPHideRow.TableNames.FieldName_condition_value”. “VPHideRow.” triggers that if the condition is true then the full row is to be hidden. This can also be substituted with “VPDeleteRow”, “VPHideColumn” or “VPDeleteColumn”. “TableNames.FieldName” is the field to compare, “condition” is the condition operator and “value” is the value to compare with.
For example “VPHideRow.Valuations.InteriorCond_eq_” will mean hide row if Valuations.InteriorCond equals to empty string (field is empty).
Output: Row automatically hidden.
If you need any help, let us know by submitting a support ticket.