Adding Sentences to Nested IF Formula, based on Impact

Anthony Barthelemy

Smartsheet Community:

I having Issues Adding Verbiage to my Formula: =IF(Impact@row = "Highest", "P1", IF(Impact@row = "High", "P2", IF(Impact@row = "Low", "P3", IF(Impact@row = "Lowest", "P4"))))

P1: The issue impedes QA and/or further development until resolved. The code cannot provide the core functionality at all unless the defect is resolved.

P1: The issue impedes QA and/or further development until resolved. The code cannot provide the core functionality at all unless the defect is resolved.

P2: A major (non-P1) function of the site produces the wrong result and while a workaround may exist, it is not acceptable for the long-term. The situation impedes usability of the site for a majority of the users.

P3: A minor function of the site produces the wrong result. A major function of the site produces the wrong result and there is an acceptable work around. The situation impedes the usability of the site for a minority of the users.

P4: Deficiencies that are cosmetic and do not impact the usability or functionality of the site. 

Thanks for the Help in Advance

Mike Wilday

Okay the formula I placed above would do the trick.

=IF(Impact@row = "Highest", "P1: The issue impedes QA and/or further development until resolved. The code cannot provide the core functionality at all unless the defect is resolved.", IF(Impact@row = "High", "P2: A major (non-P1) function of the site produces the wrong result and while a workaround may exist, it is not acceptable for the long-term. The situation impedes usability of the site for a majority of the users.", IF(Impact@row = "Low", "P3: A minor function of the site produces the wrong result. A major function of the site produces the wrong result and there is an acceptable work around. The situation impedes the usability of the site for a minority of the users.", IF(Impact@row = "Lowest", "P4: Deficiencies that are cosmetic and do not impact the usability or functionality of the site."))))

Mike Wilday

Can you describe what exactly you are trying to do? Are you trying to add the P code with the definition in each of those instances? Like below?

=IF(Impact@row = "Highest", "P1: The issue impedes QA and/or further development until resolved. The code cannot provide the core functionality at all unless the defect is resolved.", IF(Impact@row = "High", "P2: A major (non-P1) function of the site produces the wrong result and while a workaround may exist, it is not acceptable for the long-term. The situation impedes usability of the site for a majority of the users.", IF(Impact@row = "Low", "P3: A minor function of the site produces the wrong result. A major function of the site produces the wrong result and there is an acceptable work around. The situation impedes the usability of the site for a minority of the users.", IF(Impact@row = "Lowest", "P4: Deficiencies that are cosmetic and do not impact the usability or functionality of the site."))))

Anthony Barthelemy

Add the Verbiage to the Priority Column so when I select the Impact High the Priority Column Automatically Displays P1 and what P1 Means in the same Column.

Mike Wilday

Okay the formula I placed above would do the trick.

=IF(Impact@row = "Highest", "P1: The issue impedes QA and/or further development until resolved. The code cannot provide the core functionality at all unless the defect is resolved.", IF(Impact@row = "High", "P2: A major (non-P1) function of the site produces the wrong result and while a workaround may exist, it is not acceptable for the long-term. The situation impedes usability of the site for a majority of the users.", IF(Impact@row = "Low", "P3: A minor function of the site produces the wrong result. A major function of the site produces the wrong result and there is an acceptable work around. The situation impedes the usability of the site for a minority of the users.", IF(Impact@row = "Lowest", "P4: Deficiencies that are cosmetic and do not impact the usability or functionality of the site."))))

Anthony Barthelemy

Yes! It worked Perfectly. Thanks