About BigBadWol

BigBadWol · 07-29-2021

Hi! I want to make an automatically update all rows in my table. I calculate the rest of the warehouse from several tables. It is convenient to do this in a virtual column, since it is constantly updated. But I need this data in Google Sheets, respec...

BigBadWol · 07-19-2021

Hi! We create smart warehouse applications. There are tables: products - here all information about our products (ProductId - Key, Photo, Name/Size/Color - name of product, Price and others) Orders - OrderId - Key, Client - Ref to Clients, Products -...

BigBadWol · 07-23-2021

Steve: SUM(SELECT(products[Price], IN([Name/Size/Color],[_THISROW].[products]))) Yeah! This work! Thank you

BigBadWol · 07-22-2021

Constructions that i have tried: SUM(SELECT(products[Price], CONTAINS([Name/Size/Color],SPLIT([products],", ")))) SUM(SELECT(products[Price], CONTAINS([Name/Size/Color],ANY([products])))) SUM(SELECT(products[Price], CONTAINS([Name/Size/Color],ANY(LIS...

BigBadWol · 07-22-2021

I have also tried with SPLIT, like: SUM(SELECT(products[Price], CONTAINS([Name/Size/Color],SPLIT([products],", ")))). And it doesn’t work with several products in one order.

BigBadWol · 07-22-2021

In my variant: SUM(SELECT(products[Price], CONTAINS([Name/Size/Color],[products]))) And it is working, but only for 1 product. If I add a several products in 1 order, the sum = 0(

BigBadWol · 07-22-2021

I have tried “LOOKUP(products, “products”, “name/size/color”, “price”)” in App Formula, but it doesn’t work.

My Stats

nkhinvasara's Bio

Badges BigBadWol Earned

Recent Activity

Automatically update all rows

References from Enum List

Re: References from Enum List

Re: References from Enum List

Re: References from Enum List

Re: References from Enum List

Re: References from Enum List