Need to combine multiple department's reports into I'm assuming a dashboard that visually shows the status of the parts on order for the PO with status of the queues after flipped to an order. I can't figure out how to push daily status of the parts on order for the PO to a central report, but maintains the history of the previous status's.
I think I need a sheet, or mesh(?) setup,
- Primary column: PO#
- Column's that are linked, or updated w daily status:
- "Material readiness date"
- "Material status" (which indicates if I have stock to flip from PO to SO)
But if I push updates using mesh, how do I keep the previous history, per day, of the status's? I want to run analytics for the PO's to show total days from PO placed, to flipped to SO, and days in each variation of "Material Status".
Is this a sheet w/ helper column's? Is this a Mesh that pushes daily updates to multiple sheets or reports? Is this a dashboard that has to have each status setup in it's own report?
I've gone through a lot of the training videos, but I'm honestly just overwhelmed at this point! Appreciate any best suggestions.