Forum Discussion
Solved
Formulas for working out task times in a job
Below I have attached a file with an example of what I'm looking to great, I have added info to my sheet also, ill try explain what I'm looking for here also, I need a formula that can identify th...
Hi Norman_Glenn ,
Thank you for the clarification. I edited the formulas: now we are catching the "maximum" value among the delivery/remove/wrapping and using as the total of tasks. Please, check if it is correct and let me know if you need any changes.
rzaneti thank you for your reply, what you have giving me does work but their a part I need to add to the sum witch i am having the problem with, if I delivered 1 pallet that would be 1 task, if i delivered 1 and removed 1 that would still be 1 task, and if i delivered 10 and removed 20 then that would be 20 tasks not 30, is their something that can be added to the sum to reconse this
Hi Norman_Glenn ,
Thank you for the clarification. I edited the formulas: now we are catching the "maximum" value among the delivery/remove/wrapping and using as the total of tasks. Please, check if it is correct and let me know if you need any changes.
- Great help and thank you, used the max formula on the delivered and removed pallets and added the warped pallets, =MAX(B5:C5)+D5