Can't get some variables to conditional hide/dissapear in my Excel

Documents
,
1

I have an airtbale Plumsail integration.

In my Airtable, where the Plumsail is triggered, I have a single-select field called “NO COST SWITCH”; if it has any value, there should be no prices shown in the exported documents.

Then this field is looked up in the child table, and finally looked up again in my lines table, here it’s called “LU_TAKE OUT COST“

In the attached, I’ve highlighted in yellow the field I ideally want to disappear. I have the feeling that hiding the blocks will sceewe my layout? So first and foremost, I’m just trying not to show the values.

I’ve made 3 tests to see if I could get anything to disappear, however when I do the whole thing disappears in ways I don’t understand.

CleanShot 2026-02-25 at 10.32.27@2x
CleanShot 2026-02-25 at 10.32.27@2x2680×942 245 KB

My Test 1 formula is this - how to hide TOTAL VALUE?

 TOTAL VALUE ({{PRINTCURRENCY}}): {{NOCOSTSWITCH.name}:hide-block-if(value != null)}

My Test 2 formular is how to hide the values in line items. I tried first with this

{{GOODSNOTES.SALESLINES.PRINTUNITPRICE}} {{NOCOSTSWITCH.name}:hide-block-if(value != null)}

Then I tried with a Test 3 trying to use the “NO COST SWITCH” value on line level

{{GOODSNOTES.SALESLINES.PRINTTOTALPRICE}}{{GOODSNOTES.LUTAKEOUTCOST.value}:hide-block-if(value != null)}

When I don’t switch on the “NO COST SWITCH” the document looks as it should like this:

CleanShot 2026-02-25 at 10.28.30@2x
CleanShot 2026-02-25 at 10.28.30@2x2880×1384 319 KB

However once I switch on the cost switch it completely takeout whole chunks of my document like this:

CleanShot 2026-02-25 at 10.30.36@2x
CleanShot 2026-02-25 at 10.30.36@2x2880×1350 279 KB

is there a way to do this a little more subtle as I literally just want to either have empty rows/values or put “-“..?

2

Hello @kim ,

Sorry for the delayed response, and thank you for your patience.

The hide-block-if formatter works on a block level in the document rather than on a single table cell.

To better understand your scenario, could you please share your template and the JSON data used to populate it? This will help us see the structure of your data and suggest the best way to achieve the desired result.

It would also be helpful if you could briefly explain the logic you expect, for example, which values should make the cell visible and which ones should hide it.

You can send the files to support@plumsail.com and reference this conversation so we can investigate the issue for you.

If the data is sensitive, feel free to share just a few example lines or replace the actual values with sample data.

Best regards,
Aleksandra
Plumsail team