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

(Tammi Canelli) #1

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) #2

Yes you can use color type with the virtual column.

(Tammi Canelli) #3

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) #4

Save & Verify the editor and see the influence.

(Aleksi Alkio) #5

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

(Tammi Canelli) #6

@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) #7

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

(Tammi Canelli) #8

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

(Aleksi Alkio) #9

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

(Tammi Canelli) #10

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

(Aleksi Alkio) #11

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

(Tammi Canelli) #12

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.