Can I have a dropdown that has a formula AND dropdown values can be selected?


I have a dropdown (Status) that I want to be automatically updated based on another field (% Complete). I have the formula written and added to the Status column. BUT, I can't manually select/override the Status dropdown. Is there a way to do both?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!