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 |
---|---|
39 | |
25 | |
22 | |
20 | |
15 |