To have this to update automatically you need to change storage option to not store (this calculation). On the Specify Calculation box, at the bottom right click storage options, then under indexing click do not store recalculate as needed.
Oh my god I could kiss you! Although feeling really silly that I didn't know that already...
Thank you so much!!!