Auto format drop down menu

Stephanie Jean
edited 12/09/19 in Smartsheet Basics

Hello everyone, 


I am trying to set an auto format for drop down menu to give select options from another column's drop down menu. Does anyone know how I can accomplish this? 


Example: If Assignment is Compliance give me the 5 specific compliance options from a list of 20 on another column. 


Thanks in advance,