Formula to Check Restricted items in a Multi List Drop Down

Brian_Vaughan

I have a field "Failure Summary" in a sheet that has a drop down list that allows multiple selections.   I want to write a formula that will check mark those specific items in the drop down list, if a corresponding column@row has "NO" as the value in that field.  

Is it possible to write a formula to do this?

Paul Newcome

You would need to "add" multiple IF statements together along the lines of

=IF([Column1]@row = "No", "Column1 Output" + CHAR(10), "") + IF([Column2]@row = "No", "Column2 Output" + CHAR(10), "") + ………………………………

Paul Newcome

You would need to "add" multiple IF statements together along the lines of

=IF([Column1]@row = "No", "Column1 Output" + CHAR(10), "") + IF([Column2]@row = "No", "Column2 Output" + CHAR(10), "") + ………………………………

Brian_Vaughan

@Paul Newcome - This worked! Thank you very much!

Paul Newcome

Happy to help. 👍️