0

SO.. This is kinda advanced I think? I'm kinda bad at this and doesnt know where to start.

I want the column "Inställelsetid" to become either RED or GREEN depending on different choices AND timestamp.

I'll explain my setup:

Column "Ärende inkommet" and "Ärende påbörjat" is just a textcolumn with date and time i've pasted from a program. Column "Inställelsetid" is a calculated column whitch contains this formula: "=TEXT([Ärende påbörjat]-[Ärende inkommet];"h:mm:ss")" and its calculating the timestamp.

IF I have choosen LSP or MSP in the beginning of the list I want the column "Inställelsetider" to become RED if its over 2 hours and GREEN if its under 2 hours.

IF I have choosen HSP in the beginning of the list I want the column "Inställelsetider" to become RED if its over 1 hour and GREEN if its under 1 hour.

Is this possible?

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.