Auto fill column?
I don't know if this is a possibility or not but I'm hoping someone can help. I'm looking to see if it's possible to set a formula/equation/conditional formatting so that what's entered in one column will autofill another.
Example: I have a column called Access Requested (dropdown) and another called Type of Credential. When Press is selected in the Access Requested column, I want the Type of Credential column to auto fill in Press Pass.
Any suggestions? Nothing in conditional formatting seems to help, though I am using this for other purposes. Thank you all in advance!