Struggling with multiple IF Statements

Options

I am new to Smartsheet and struggling a bit to get Multiple IF Statements to work. I'm trying to get a number/score to render to an adjacent cell when an item is selected in the cell beside it. Having absolutely no luck here. (Attempted) Syntax below. Thanks in advance for your expertise.


IF([Strategic Alignment]1 = "Patient Safety", “5”, IF([Strategic Alignment]1 = " Growth - EBITDA, Net Revenue, Volume", “5”, IF([Strategic Alignment]1 = " Clinical Quality", “4”, IF([Strategic Alignment]1 = " Clinician Engagement & Experience", “4”, IF([Strategic Alignment]1 = " Client Retention", “4”, IF([Strategic Alignment]1 = " Operations Excellence - Cost Reduction", “4”, IF([Strategic Alignment]1 = " Administrative Optimization", “4”, IF([Strategic Alignment]1 = " Operational Stability/Reliability", “3”,)))))))) 

Best Answer

Answers

  • James Bristow
    Options

    PS. I recognized the space between the " and the first letter of the values and made adjustments with no luck

  • James Bristow
    Options

    Works great, thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!