what kind of formula would I need to do the following?

Octavio lopez
edited 12/09/19 in Smartsheet Basics

I am trying to figure out a formula that when I change the value of the %complete to %100 my status column with drop down list pics a specific word and fills it in the cell. Can this be done?