I have a list which 4 statuses. New, claimed, pending and completed. I need to highlight items which are in the new status for longer than 3 hours. I've read that using the =today() function isn't possible in SharePoint. Is there anyway I can accomplish this?
You could filter using a calculated column (call it Highlight) and putting in '[Created] + 3 hours'. Then you know that If [Created] is greater than or equal to the Highlight column.