Hello!
Today I got a working code to make my label turn either red (Exceeds time) or green (Before time) depending if the date/time in the label exceeds the Now() value.
But I also want the label to be able to turn orange if its 15min until the timer runs out. Is this possible?
I got this code:
If(IsBlank(ThisItem.'Last Contact');RGBA(0;0;0;0);
If(ThisItem.'Last contact'<= thecolor;RGBA(242;38;19;1);RGBA(0;255;42;45)))
The timer "thecolor":
Set(thecolor; Now())