Trying to get specific text to show in a column if a value in cell is less than 4


Here is my scenario:


I have 6 columns Sheet. I want the name of the first column where the value of a cell is less than 4, to populate a 6th column. In other words, dealing with one row at a time, if my column names are Awareness, Desire, Knowledge, Ability, Reinforcement, and Barrier Point, I want the name of the column of the first 5 columns (Awareness, Desire, Knowledge, Ability, Reinforcement) where the value is less than 4 to appear in the Barrier Point column.

Here is where I am:

=IF(B2 < 4, "Awareness", IF(C2 < 4, "Desire", IF(D2 < 4, "Knowledge", IF(E2 < 4, "Ability", IF(F2 < 4, "Reinforcement", "")))))

Coming up as #UNPARSEABLE. Help please?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!