LinkedIn
Twitter
I have two tables and an action button. whenever I add [qty_sold],[price_sold], [type] for a product in orcan_form it lists it in a new row in "orcan "sheet. now, someone here helped me make an action button so that the value of [qty_sold],[price_sold], [type] is also updated in "inventory" sheet. However, it only updates my last transaction of that item and not the sum off all value for that item. i provided the expressions that he used in the screenshot below. they somehow need the "sum()" function somewhere. NO MATTER how much i tried wrapping the expressions in a sum function i kept getting an error. Is this fixable?
[type] = IFS(
[type0]="kept", "kept",
[qr_code].[qty_to_sell]-[qty_sold] = 0, "sold",
[qr_code].[qty_to_sell]-[qty_sold] > 0, "selling"
)
