Formula takes a few seconds to populate after the sheet is opened
What could be the root cause for a formula not populating until a few seconds after opening a worksheet?
I built a formula off of a contact cell that references a roster to show an individuals manager but unlike all the other formulas in the sheet, this one takes a few seconds to calculate, it is throwing off my reports as the report shows blank until i go into the worksheet and let it load. Formula is below for reference:
hopefully I explained this well enough
Help Article Resources
Check out the Formula Handbook template!