Im using google sheet and i would like to do the following
if i enter a value in a specific cell, i would like other cells in the same row to be filled automatically
H3="red"
Then automatically the following cells are filled:
J3=pete
K3=tom
R3=bob
If i enter
H3="blue"
Then automatically the following cells are filled:
J3=lauren
K3=Jef
R3=william
if i enter a value in a specific cell, i would like other cells in the same row to be filled automatically
H3="red"
Then automatically the following cells are filled:
J3=pete
K3=tom
R3=bob
If i enter
H3="blue"
Then automatically the following cells are filled:
J3=lauren
K3=Jef
R3=william