Dynamic Formula Field / Trigger formula field on viewing record
I would find it very useful (and I'm sure many many others!) if you could alter the formula field to be triggered on viewing a record so it acts dynamically.
This would probably be best to have a toggle switch to select if you want it to run on record view, incase some people don't want that particular method for their business.