My current formula:
LOOKUP( [Date] , “Molding Manpower” , Production Date , Total People)
It returns the total people working in a workcell on a given date from my Molding Manpower table.
The problem is I have multiple shifts and operations. I need to match the “Date”, “Shift”, and “Mixer Number” and return the Total People.
I feel like in excel I would use filter() or multiple nested if() statements.