currently I am working on a status indication column like a "traffic light" for a Sharepoint list that is able to display a green/yellow/red light depending on the fulfillment of a task. I've found very interesting blogs from users which are doing quite similar things via
My requirements for this status indication are a bit more demanding - the column logic has to check two things at the same time. First, how much time is left until a deadline (4months, 3months, ..., down to 1month). Second, what is the fulfillment status task considering the time left until deadline. This means that a task fulfillment of 10% and 4months left would i.e. result in a yellow light, whereas 10% and 3 months left would result in a red light. So it is basically a comparison of time until deadline and task fulfillment status.
My reference variables are _SNR_Status, displaying the task fulfillment in % and _KPI_SoP, representing the Deadline in date format. The other variables lessone,.... lessfour represent the time until deadline (counting from _KPI_SoP backwards)
Thanks and best regards