Does anyone know a way for tracking quantity deduction when it comes to material requests ?

Brendan Ginns

I have been trying to track via the activity log on the right hand of the sheet, however the reports are taking too long to produce. I just need something that i can send to the accounts team that shows how much material was used in a week.

Please let me know if anyone has a solution.

Thanks,

Brendan

Debbie Sawyer

Can you expand your scenario a little Brendan. Maybe explain the sheet, how do you determine and log materials used. It sounds like a countif would work possibly.

Brendan Ginns

Hi Debbie,

Thanks for your response. So we have an active sheet of all of our inventory items. Right now we have a quantity column that needs to be deducted from. We essentially need to track those deductions ( i.e Material Request) on a daily basis. Please let me know if this is enough information.

Thanks,

Brendan

Debbie Sawyer

HI Brendan

Do you have 5 mins to zoom and show me?

My email address is: debbie.sawyer@smarterbusinessprocesses.com

I think seeing it will aid my response! I am more than happy to help if I am able to! :D

Kind regards

Debbie