Formula question

Shannon Scarbrough
Shannon Scarbrough ✭✭✭✭
edited 12/22/21 in Formulas and Functions

I have one drop down column "Turbine Operational" with the options Yes or No. Another column "MW Impacted" is a text column. I'd like to be able to input numbers into the MW Impacted Column, but if the Turbine Operational column has "Yes" selected, then that overrides my inputs and puts the cell at 0. Any insights appreciated. Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!