Forum Discussion
ChayceDuncan
10 months agoQrew Captain
You'll need to make sure your report name is formula rich-text, and then something like this will work:
var bool overdue = (Today() - [Last Opened Date]) > Days(120);
var text name = [Field that actually has the report name]; //This is the text that will show in your element
"<p style='text-align:center; width: 100px; " & if( $overdue, "background: red; color:white;"'>" & $name & "</p>"
The <p> tag just make it a block element so you can set a standard width to make the column look the same width up and down, adjust as needed. In the above I just have it setting the background to red and font-color to white, you can plug in your own hex color or alternate color though as needed.
------------------------------
Chayce Duncan
------------------------------