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
Yes you can use color type with the virtual column.
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?
Save & Verify the editor and see the influence.
The app formula result just needs to be a color like =IF(ISBLANK([Column]),“Red”,“Blue”)
@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”, “”)
IFS(ISNOTBLANK([DementiaAlzheimers]),“Red”), IFS(ISNOTBLANK([ElectricWheelchair]), “Yellow”), IFS(ISNOTBLANK([NeedMobilityAssist]), “Yellow”), IFS(ISNOTBLANK([WheelchairOrScooter]), “Yellow”), IFS(ISNOTBLANK([InsulinDep]), “Blue”)
When I verify the expression it cuts off after the first IFS statement…should everything show here?
It’s just doesn’t show the whole, but it should work.
It appeared to show when I tested it, but then in the table view only the red color showed up,
IF(ISNOTBLANK([DementiaAlzheimers]),“Red”, IF(ISNOTBLANK([ElectricWheelchair]), “Yellow”, IF(ISNOTBLANK([NeedMobilityAssist]), “Yellow”, IF(ISNOTBLANK([WheelchairOrScooter]), “Yellow”, IF(ISNOTBLANK([InsulinDep]), “Blue”,"")))))
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.
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"
)
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |