How do I change the value in one column cell based on what is selected in another cell (dropdown)
Hello,
I am not a coder but I am trying to find out how can I make a form so that when one value is selected in "column A" it will automatically populate a certain value in "column C. Please see attached image. There are two options to choose from in each of the columns, so:
If "option 1" is selected in column A, then "value A" will populate in column C; or
If "option 2" is selected in column A, then "value B" will populate in column C
Thanks ahead for any assistance!
