Visibility formula

Hello~

I'd like to hide the zero-Stock row.
Please teach me the way.

Hi @sangmin,

Thanks for getting in touch. On my end, I've tried a similar scenario.

An inventory table sample is shown below:

Screen Shot 2021-08-25 at 4.44.55 PM

In the screen, you can use the List Properties > Data and Set Source by using the FILTER() formula, as shown below. The rows with 0 stocks will be hidden.

=filter(Inventory,"Inventory[Stock]<>””0”””)

This is how the data will appear on the screen.

Screen Shot 2021-08-25 at 4.47.30 PM

Hopefully, this will help. If you have any further questions, do not hesitate to contact us.

1 Like

Oh, it's not visibility, it's from the source. It's been a lot of help. Thank you Pankaj~

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.