Wednesday, January 18, 2017

Show image in SharePoint calculated column based on the status of another column

Calculated column
  • Create a calculated column : Indicator
  • Type : Calculated
  • Formula :
="<DIV><img src='" & IF(DaysInWorkshop=1, "/SiteAssets/Images/green.png", IF(DaysInWorkshop=2,"/SiteAssets/Images/yellow.png", IF(DaysInWorkshop>=3,"/SiteAssets/Images/red.png"))) & "'></DIV>"

where, DaysInWorkshop is a Number column in my list.
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Clearing Person/Group Values

To clear out or empty the values in person or group columns, how you do it depends on if the column is single-value or multi-value. For ...