I have recently created a form for our technicians who are out at client sites doing asset inspections. Often they need to replace items on the asset, i.e., fans belts, filters, light bulbs, etc.
Currently the form asks if a purchase was required and if yes, how many items were purchased?
Whichever of the options above that is selected is the number of subsequent items to be completed. i.e., 'Yes-4 Items' will then require you to complete
- description
- quantity
- unit price
- vendor
4 times.
Each of the above will land in a separate column in the worksheet.
In order for finance to monthly reconcile corporate vendor accounts they will comb through the purchases.
My challenge is how do I compile all the purchases across the multiple columns?
Above screenshot illustrates 3 purchases from corporate vendor 'Grainger'.
There are some entries where there are 7 purchases, possibly all from 'Corporate Vendor 1' or some from 'Corporate Vendor 1' and some from 'Corporate Vendor 2'.
I would like to have a worksheet OR a report that would compile ALL 'Corporate Vendor 1' purchases within a specific timeframe and then ALL 'Corporate Vendor 2' purchases within a specific timeframe.
I'm having trouble coming up with a solution.
If I use the Pivot App, I will still have a column for each identified purchase, i.e., MATL 1, MATL 2, MATL 3, etc.
Appreciate any and all thoughts.