Formula field not refreshing

If I am not explaining properly please let me know. As I would expect that should work seamlessly without any issues but it seems to be needing some work around.