Hi,
I need help... please see the picture attached...
column A; A - Date
column B - team#
column C - status
column D - assigned location
column E - Current location
column F - Actual location, only if the value on the columns e:e is OTHERS
so, I need your assistance example, for the 1st October, for team# 116 the assigned location is Garage 3 but this team was deployed on other than assigned location, this case "others", then if the value is others in the column E (current location, the user will enter the actual location column F example Shop3 in this case)
from G7 - P7 I have all the team# and need to show the result as follows:
Team 14 is working in the assigned location, Garage 1
Team 115 same
Team116 is not working on the assigned location but in the Shop 1; once I enter OTHERS in the current location, I need result from the next column (cells highlighted in yellow just for easy look)
any help... or thoughts?
I need help... please see the picture attached...
column A; A - Date
column B - team#
column C - status
column D - assigned location
column E - Current location
column F - Actual location, only if the value on the columns e:e is OTHERS
so, I need your assistance example, for the 1st October, for team# 116 the assigned location is Garage 3 but this team was deployed on other than assigned location, this case "others", then if the value is others in the column E (current location, the user will enter the actual location column F example Shop3 in this case)
from G7 - P7 I have all the team# and need to show the result as follows:
Team 14 is working in the assigned location, Garage 1
Team 115 same
Team116 is not working on the assigned location but in the Shop 1; once I enter OTHERS in the current location, I need result from the next column (cells highlighted in yellow just for easy look)
any help... or thoughts?