I am working on creating sharepoint dashboard using color coding. I have my custom list created and all of the traffic lights are working based on condition user provides. Following is the basic set up of my list
Program: Single Line Text Light 1: Calculated Field Light1Link: Hyperlink Light 2: Calculated Field Light2Link: Hyperlink Light 3: Calculated Field Light3Link: Hyperlink Light 4: Calculated Field Light4Link: Hyperlink
Now is there a way that when user clicks on those individual lights will get directed to Hyperlink provided in Light1Link, Light2Link, ... Light4Link?
="<DIV style='font-weight:bold; font-size:24px; color:"&[Tech]&";'>•</DIV>"
Which gives me Green light if Status of [Tech] column is Completed, Yellow IF [Tech} is In Progress, and Red if [Tech] is Not Started.