Tricky KPI › Forums › General discussion › Tricky KPI Tagged: Calculated Column, Js, KPI This topic contains 1 reply, has 2 voices, and was last updated by Alexander Bautz 3 months, 1 week ago. Author Posts June 6, 2019 at 17:02 #25610 beccaParticipant I got a new request from one of my users to add alerts to a tool I made based on multiple fields and the current date. Originally I was thinking I’d use an elaborate calculated column to do a solution like outlined here https://sharepoint.stackexchange.com/questions/204802/status-indicators-on-sharepoint-online but I didn’t realize [Today] isn’t usable in calculated columns. My formula was =IF(IF(Weekday([Intake Date])>6,[Intake Date]+41,IF(Weekday([Intake Date])>1,[Intake Date]+42,[Intake Date]+40))<[Event Date],"At-Risk",IF(AND(IF(Weekday([Event Date])>6,[Event Date]+27,IF(Weekday([Event Date])>1,[Event Date]+28,[Event Date]+26))<[Today],OR([Request Type]<>"",[Request Approval Type]="Non-Standard")),"SLA At-Risk",IF(AND(IF(Weekday([Modified Date])>6,[Modified Date]+27,IF(Weekday([Modified Date])>1,[Modified Date]+28, [Modified Date]+26))<[Today],[Event Date]>[Today],"Aging","No Risk"))) Is there a way to instead of just looking at a certain field to use my conditions for each directly in the “case” sections of the code for the KPI and apply the color coding to the title field in the list view? June 9, 2019 at 09:32 #25644 Alexander BautzKeymaster When you are using SP 2013 your only real good method for modifying a list view is to use JSLink. I don’t have an example matching your specific request, but I did make a tool to attach a JSLink script to a field in a list back in 2015: https://spjsblog.com/2015/07/19/jslink-add-client-side-rendering-to-a-field/ Look at the example and see if you can adapt the code to your need. You may find some useful snippets here: https://code.msdn.microsoft.com/office/Client-side-rendering-JS-2ed3538a Alexander Author Posts You must be logged in to reply to this topic.