Can I use the color type in a virtual column?...

[Tammi_Canelli]

Can I use the color type in a virtual column?

If so, how could I show:

[Col1] if true = red, OR([col2] if true=blue, [col3] if true = blue [col5] if true = yellow

[Aleksi_Alkio]

Yes you can use color type with the virtual column.

[Tammi_Canelli]

okay, how?

I’ve never used this column type before.

Is it only one color per row?

or can I have more than one color if all criteria met?

[Aleksi_Alkio]

Save & Verify the editor and see the influence.

[Aleksi_Alkio]

The app formula result just needs to be a color like =IF(ISBLANK([Column]),“Red”,“Blue”)

[Tammi_Canelli]

@Aleksi_Alkio this is what i want but i keep getting an error.

Don’t think i’ve mentioned today how much i hate expressions…

IF(ISNOTBLANK([DementiaAlzheimers]), “Red”, “”), IF(ISNOTBLANK([ElectricWheelchair], “Yellow”, “”), IF(ISNOTBLANK([NeedMobilityAssist], “Yellow”, “”), IF(ISNOTBLANK([WheelchairOrScooter], “Yellow”, “”), IF(ISNOTBLANK([InsulinDep], “Blue”, “”)

[Aleksi_Alkio]

IFS(ISNOTBLANK([DementiaAlzheimers]),“Red”), IFS(ISNOTBLANK([ElectricWheelchair]), “Yellow”), IFS(ISNOTBLANK([NeedMobilityAssist]), “Yellow”), IFS(ISNOTBLANK([WheelchairOrScooter]), “Yellow”), IFS(ISNOTBLANK([InsulinDep]), “Blue”)

[Tammi_Canelli]

When I verify the expression it cuts off after the first IFS statement…should everything show here?

[Aleksi_Alkio]

It’s just doesn’t show the whole, but it should work.

[Tammi_Canelli]

It appeared to show when I tested it, but then in the table view only the red color showed up,

[Aleksi_Alkio]

IF(ISNOTBLANK([DementiaAlzheimers]),“Red”, IF(ISNOTBLANK([ElectricWheelchair]), “Yellow”, IF(ISNOTBLANK([NeedMobilityAssist]), “Yellow”, IF(ISNOTBLANK([WheelchairOrScooter]), “Yellow”, IF(ISNOTBLANK([InsulinDep]), “Blue”,"")))))

[Tammi_Canelli]

Thank you.

Couldn’t get all three colors to show in one column so I ended up creating 3…would like the columns closer together but this works for now.

[cuadromoreno]

In my experience, Virtual Columns don't accept color type in the case of:

IFS(

[Stock actual] > [Stock mínimo], "Green",
[Stock actual] = [Stock mínimo], "Yellow",
[Stock actual] < [Stock mínimo], "Red"

)