Solved: Hiding Virtual Price Columns in Detail View if Zer... - Page 2

NorthstateAutoB · 04-02-2023 03:26 PM

Hello Again everyone. I've successfully identified a bunch ways to show or not show columns in detail view. What I'm struggling with is Virtual Columns that have a price formula. I would really like to hide these columns if they are zero... And one column based on a yes/no column, no matter the value. These columns seem to ignore any show_if formula I use. I've tried very straight forward formulas like [ColumnName]<>0 or NOT([ColumnName]=0). Even "0.00". Aside from the Not Zero aspect, I've hidden columns using CONTEXT() formulas like NOT(CONTEXT(ViewType)=Detail) which has worked for every other column I've used it on but it hasn't worked for the virtual columns. Any ideas? These virtual columns are price total columns. They add together 2 or more price columns with very basic formulas like [ColumnName]+[ColumnName]. Let me know if I need to add any extra information

NorthstateAutoB

I found the solution to my problem!! I tried everything but I just now came across the Blank value comparison mode option. There's 2 options, Legacy and Consistent. I had chosen Consistent a very long time ago and I didn't know how that would change the way my expression would need to be written. Here's the page explaining how it changes the result in expression with blanks. https://support.google.com/appsheet/answer/11510515?visit_id=638174459550696120-1193301008&p=configu...

When I changed my expression of virtual columns catagorized as Price from any kind of zero to "0.01" It worked. So now my show ifs expressions look like these [Column] >= 1 or [Column] >= "0.01". Now they now longer show in detail view if the value is 0 or 0.00. Thanks everyone for your help!

EDIT: It did fix most of the columns but there's still some hiccups with desktop view. I'm largely happy with the result though

View solution in original post

Hiding Virtual Price Columns in Detail View if Zero