I have a list that tracks loaned equipment. I want a little icon that is a visual indication at how long the item has been on loan to help visually cue employees to follow-up.
0-4 hours: green icon
4-8 hours: yellow icon
8+ hours: red icon
My first thought was using a "IF
NOW + 4hrs >=
CREATED Then ..." function in a calculated field. I've been on a Google manhunt looking for a simple way to implement a
TODAY call in a calculated field; I've learned, however, that since a calculated field is only generated once (it is static) when the item is saved, it's not going to help me.
NOW logic based on the
Anyone have other ideas or suggestions?
PS: I don't have access to SharePoint Designer. Am just a user.