Friday, March 27, 2009

Calculated Column with Four Options

Column One - drop down with four choices type Choice
Column Two - Calculated column that displays a path name to a file depending on one of four choices in the drop down.
=IF( [ColumnName]="Choice One","First.jpg",IF( [ColumnName]="Choice Two","Second.jpg",IF([ColumnName]="Choice Three","Third.jpg",IF([ColumnName]="Choice Four","Fourth.jpg" ))))

No comments:

Post a Comment