Struggling with multiple IF Statements

James Bristow

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”,)))))))) 

John Jonassen

Hi @James Bristow

Try this:

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

James Bristow

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

John Jonassen

Hi @James Bristow

Try this:

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

James Bristow

Works great, thanks!