Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a column in TABLE with this formula ==> =Interval(Now()-Last_Update_Date,'h')
and I would like show the column green (#93c47d) when this value is >= 48. I tried this, but the background is always white
=if(Interval(Now()- Last_Update_Date,'h') >= 48, '#93c47d', white())
Thanks in advance
Interval is a formatting function, i.e. - it doesn't change the underlaying number. Try like:
if(Floor((Now()- Last_Update_Date)*24) >= 48, '#93c47d', white())
Note: you might not need floor() based on your requirement.
Hi,
You can try this:
=if(Interval(Now()- Last_Update_Date,'h') >= 48, RGB(147,196,125), white())
Interval is a formatting function, i.e. - it doesn't change the underlaying number. Try like:
if(Floor((Now()- Last_Update_Date)*24) >= 48, '#93c47d', white())
Note: you might not need floor() based on your requirement.