Editing formula within multiple calculated fields concurrently

Question

I have a pivot table with monthly run-rate forecast. e.g. on the 5th of Jan it would be [number]/5 *31

I change it every week so 5th/ 12th/19th etc.

Only problem is I have lots of fields like this and lots of tables and lots of sheets. Is there any way to update the calculated fields in bulk?

Thanks

Sven · Answer 1 · 2019-05-14T09:46:31.517

1

You should consider now() formatted to give the week. Then call that value in your calcs... should update with every change of week

edited May 14 '19 at 09:46

answered May 14 '19 at 08:13

Sven

Thanks Mike, I agree but wasn't able to comment yet. So thanks! :) Should I delete and/or put a comment instead? – Sven May 14 '19 at 09:07
Get in quick and put my suggestion with now() :) – Solar Mike May 14 '19 at 09:15
Thanks Mike, appreciate your help. – Sven May 14 '19 at 09:47

1 Answers1