Trying to fill a rectangle shape in a gallery based on a selection.
Using formula below, but not working:
If(ThisItem.'Risk Status'.Value="OPEN",RGBA(235, 130, 125, 1), Or(ThisItem.'Risk Status'.Value="CLOSED", RGBA(115, 205, 170, 1), Or(ThisItem.'Risk Status'.Value="VALIDATED", RGBA(255, 153, 51, 1)) Could anyone help? Thanks a million!
Try using below formula:
If(ThisItem.'Risk Status'.Value = "OPEN", RGBA(235, 130, 125, 1), ThisItem.'Risk Status'.Value = "CLOSED", RGBA(115, 205, 170, 1), ThisItem.'Risk Status'.Value = "VALIDATED", RGBA(255, 153, 51, 1), RGBA(255, 255, 255, 1)) I have added default color as RGBA(255, 255, 255, 1) at the end of the formula. You can change it as per your requirements or skip it.
Documentations:
