Hello Team,
Currently the user is using excel to create quotations. There is one Summary sheet which links to 10 individual product sheets. Reason being the end product is created using 10 sub-products and hence for each of them there is an individual sheet, they have different types of calculation for each sub product and that also means different data structure (hence it cannot be consolidated).
Once individual product sheets are computed and ready, there are some additional fields (like price, discount, terms/mode of payment, etc.) in the Summary sheet which are discussed and finalized with the customer and then a pdf file needs to be created to send it across to the customer. One important rule is there can be multiple quotations created before a quotation is finalized with the customer.
I want to bring this to App sheet and wondering how best this can be implemented. Any suggestions please?
LinkedIn
Twitter
