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
-
There is not a way to do both. It would need to be fully automated or fully manual.
Answers
-
There is not a way to do both. It would need to be fully automated or fully manual.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!