Ive been doing alot of reading into getting [Today] to work within a calculated column but im starting to wonder if theres a better solution staring me in the face
Basically we have an asset register where we highlight what asset is allocated to who. We'd like to highlight when someone has left the company and not returned the item. My initial thought was to create a leaving date column and set up a calculated column that says, when leaving date is less than todays date, flag the status as not returned (ive been asked to make it as visual as possible so was thinking of using calculated columns HTML capabilities to highlight the status as red)
Am i using calculated columns wrong here? Is there a way of using a workflow that will do what im looking for in a simpler way than the workarounds ive been reading online to the [Today] conundrum?