conditional fill a cell with value from another cell in the same sheet
I have a travel request form that user can fill out for self or for someone else. Fields involved are:
Requestor Name - person completing the travel form
Request for - who travel request is for. Value options are "Self" or "Someone Else"
Traveler Name - If request is for "Someone Else" then Requestor types in Traveler name
Question/Need: If Request For = "Self" then I want Traveler Name to populate with "Requestor Name"
Help Article Resources
Check out the Formula Handbook template!