I need to display a date/time in the pivot. I've managed this via widget script, but that makes conditionally formatting virtually impossible, as the date is not really a date (i need to colour them based on how old the record is, so i can't simply subtract 30 days)
I created a second column called "indicator" based on conditions that goes 0,1,2, but now i want that indicator to be a symbol, and joined into the cell... is there a way to do this?
