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
-
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.
-
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
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives