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 



Best regards

Answers

  • Andrée Starå
    Andrée Starå Community Champion

    Hi Christine,

    Yes, it’s possible. I’d recommend using update requests to ask for the information.

    You can select which columns should be included.

    More info: 

    Would that work?

    I hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Hi @Andrée Starå

    I understand the request functionality. I am trying to find out how to work with more than 2D i SmartSheet like you do in excel , when you use the pivot table. AND using the automated workflows... :-) I am not sure its doable, but pretty sure.

    I want that Klaus and Henrik every month is prompted automatically, to update their information on lab, office and diverse (without being able to edit previous months)

    I want to have an internal overview of sum of office, labs and diverse as well as the distrubtion on users.

    Further more, I want to calculate how much they should pay each month, and I want to see my income per lab and office.

    Below are 2 pictures, one is raw data i excel and the other a pivot


  • Andrée Starå
    Andrée Starå Community Champion

    @Christine Rosenberg

    Please see my answers/comments below.

    I want that Klaus and Henrik every month is prompted automatically, to update their information on lab, office and diverse (without being able to edit previous months)

    A: Yes, it's possible. We would need a helper column to set a date from the month that would automatically send the update requests as needed. If needed we can lock the rows after the informations is added.

    I want to have an internal overview of sum of office, labs and diverse as well as the distrubtion on users.

    A: We'd either att those metrics together in the same sheet somewhere or in the Sheet Summary section or in a so-called Master Metric Sheet. The right choice depends.

    Further more, I want to calculate how much they should pay each month, and I want to see my income per lab and office.

    A: Same as previous question.

    What do you think? Make sense?

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.