Hello, Please kindly help me. I use app sheet to make sales invoice. I have default price for each items, but I may sell different price (cheaper than default price) to some special customers, and some discount (cheaper price) for large quantity of sales.
Each time, I add new item, my price is editable. I want to show 1) default price (normal price that is already set), 2) history price for special customers (the price is this items sold to this customers last time), and 3) when the sales qty reach certain number, I want app sheet to show the suggested wholesale price (which is pre-set based on volume).
Please kindly help me with the expression to get 2 (history price) and 3 price (volume-based price).