Auto fill column?

SPalmieri ✭✭
edited 12/09/19 in Formulas and Functions

Hi, everyone.

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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!