locked
How can i create a column to ratings in color pattern? RRS feed

  • Question

  • I'm suppose to create a column in Sharepoint which shows low/medium/high rating using a color scheme using a grid as seen below.

    I seen this done and i think i this how they did but not sure what formula or how they actually did it to get end result.

    1.  Used the grid.  probability and impact combined show rating in  color (green, yellow, Red) Maybe each number represents a color but, what about number 5.  5 can be green and yellow. What can be done here?

    http://www.eggheadcafe.com/FileUpload/-2051988918/grid.JPG


    2. Create a "color" column which has options of Green, yellow and Red.

    3.  The results show in "Rating" column, a bar in color.


    http://www.eggheadcafe.com/FileUpload/-2051988918/asseen.JPG

    How did they do this?  How can i create a column to show ratings in color using the grid.  

    Please avoid code as I'm not a programmer.

    Thank you so much

    • Edited by Mike Walsh FIN Wednesday, June 15, 2011 5:15 PM Some people still are on slow lines. They do NOT want to be forced to open images. So post the URL to the image NOT the image itself so they have the choice
    • Moved by Mike Walsh FIN Friday, June 24, 2011 7:15 AM not general (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    Wednesday, June 15, 2011 3:54 PM

Answers

All replies

  • Look at using a calculated column.  these two posts should help get you started:

     

    http://blog.pathtosharepoint.com/2008/08/07/calculated-columns/

    http://blog.pathtosharepoint.com/2008/09/01/using-calculated-columns-to-write-html/

     

    Good luck!

    Mark


    The SharePoint Hillbilly
    Fewer Big Words... More Pretty Pictures... http://www.SharePointHillbilly.com
    • Marked as answer by Peng Lei Wednesday, June 22, 2011 3:21 AM
    Wednesday, June 15, 2011 5:00 PM
  • another idea...

     

    Using a Data View Web Part:

    Add a new column

    In that column, drop in a text box

    Apply conditional formatting to the text box to change the color depending on a value.

     

    code example:

    <asp:TextBox runat="server" id="TextBox1{generate-id()}">

    <xsl:attribute name="style">

    <xsl:if test="@ID &lt; '5'">background-color: #0000FF;</xsl:if>

    <xsl:if test="@ID &gt; '5'">background-color: #FF0000;</xsl:if>

    </xsl:attribute>

    </asp:TextBox>

    Logic:
    ID < 5 make the field blue
    ID > 5 make the field red

     

     


    http://www.sharepointed.com
    Wednesday, June 15, 2011 5:20 PM
  • This is getting a little complicated so let's make it simple. I want SharePoint to say "Yellow, Blue or Red" based on a scale. <5=yellow <10=blue <15= red I already have column (Rating) which shows the value. Now how do i get SharePoint to say which color each value represents in separate column? Please no code, as I'm not a programmer.
    Tuesday, June 21, 2011 4:46 PM
  • Do you know how to edit a page in SharePoint Designer?

    I'll write an EDU if you can edit the page...


    http://www.sharepointed.com
    Wednesday, June 22, 2011 7:19 PM