I want a column to become either RED or GREEN depending on different choices in another column

%3CLINGO-SUB%20id%3D%22lingo-sub-995833%22%20slang%3D%22en-US%22%3EI%20want%20a%20column%20to%20become%20either%20RED%20or%20GREEN%20depending%20on%20different%20choices%20in%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-995833%22%20slang%3D%22en-US%22%3E%3CP%3ESO..%20This%20is%20kinda%20advanced%20I%20think%3F%20I'm%20kinda%20bad%20at%20this%20and%20doesnt%20know%20where%20to%20start.%3C%2FP%3E%3CP%3EI%20want%20the%20column%20%22Inst%C3%A4llelsetid%22%20to%20become%20either%20RED%20or%20GREEN%20depending%20on%20different%20choices%20AND%20the%20calculated%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EI'll%20explain%20my%20setup%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EColumn%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%22%C3%84rende%20inkommet%22%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%22%C3%84rende%20p%C3%A5b%C3%B6rjat%22%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eis%20just%20a%20textcolumn%20with%20date%20and%20time%20i've%20pasted%20in.%20Column%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%22Inst%C3%A4llelsetid%22%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eis%20a%20calculated%20column%20whitch%20contains%20this%20formula%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CEM%3E%22%3DTEXT(%5B%C3%84rende%20p%C3%A5b%C3%B6rjat%5D-%5B%C3%84rende%20inkommet%5D%3B%22h%3Amm%3Ass%22)%22%3C%2FEM%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%20its%20calculating%20the%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIF%20I%20have%20choosen%20LSP%20or%20MSP%20in%20the%20beginning%20of%20the%20list%20I%20want%20the%20column%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%22Inst%C3%A4llelsetider%22%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eto%20become%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ERED%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eif%20its%20over%202%20hours%20and%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EGREEN%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eif%20its%20under%202%20hours.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIF%20I%20have%20choosen%20HSP%20in%20the%20beginning%20of%20the%20list%20I%20want%20the%20column%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%22Inst%C3%A4llelsetider%22%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eto%20become%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ERED%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eif%20its%20over%201%20hour%20and%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EGREEN%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eif%20its%20under%201%20hour.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F155889i848C18AB59A0EE4C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Greenandred.png%22%20title%3D%22Greenandred.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-995833%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-998539%22%20slang%3D%22en-US%22%3ERe%3A%20I%20want%20a%20column%20to%20become%20either%20RED%20or%20GREEN%20depending%20on%20different%20choices%20in%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-998539%22%20slang%3D%22en-US%22%3ESomeone%20that%20can%20help%20me%20or%20tell%20me%20if%20this%20even%20possible%3F%3D)%3C%2FLINGO-BODY%3E
Contributor

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 the calculated value.

 

I'll explain my setup:

Column "Ärende inkommet" and "Ärende påbörjat" is just a textcolumn with date and time i've pasted in. 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 value.

 

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?

 

Greenandred.png

 

1 Reply
Someone that can help me or tell me if this even possible?=)