[ATTACH]3593Untitled.jpgtime-tracking-template (1).xlsx67[/ATTACH]
Here is what I need: In the hours shipped column.. (I14)
IF the task ID contains the word Shipping Multiply Hours x1
If the task ID does not contain the word shipping Multiply Hours x0
I need to see the function too b.c i have to do the same for Hours Received but if the word Received is under Task ID.
Also the Task ID is a pivot table that has like 3 or 4 options for each location (Shipping-TL, Shipping- LTL...etc)
Thank you in advance.. Not matter what I enter i get this error #NAME
Bookmarks