updating cells without loosing easy overview of historic data - how to?
We have a list of customers, where the invoice changes from month to month according to use of specific items. Example: Customer A will in
January pay for 2 item Y, 0 zero item X, and in
February pay for 3 item Y, 0 item X and in
March pay for 1 item X, 3 item Y.
Q1: Is it possible to have the customer update this information monthly? Via a form? Via a request?
Q2: Is it possible to have this kind of information in SmartSheet without overriding previous information? We are interested in having a historic view of the items paid for by the customer.
I am looking for a smarter(automated) way of working than having this very manually process of adding additiona coulumns in xlxs