Jan 24 2022 08:19 PM - edited Jan 30 2022 01:12 PM
Jan 24 2022 09:01 PM
Jan 25 2022 11:25 AM
Hi @Donald_Genes_, Please see attached for fake example. Hopefully, this is what you're looking for. Let me know what you think..
Feb 17 2022 07:34 AM
Feb 17 2022 07:56 AM
Mar 12 2022 12:59 PM
@mathetes Please review attached and let me know if you think this will help.
Mar 13 2022 04:36 PM
@ALM I am not entirely sure if this is the kind of thing you're looking for. Again, you are familiar with your data, your situation. So I was doing my best to guess from the spreadsheet and your earlier description. The formula shown below is in column R, and gets the total of the allocated quantities from the inventory sheet for each item number shown in column B of the forecast sheet. You can then compare those totals with your quarterly projections---I"m assuming you can do that part.