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:

=IFERROR(IF([Assigned To]@row <> "", INDEX({All Pod Detail Range 1}, MATCH([Assigned To]@row, {All Pod Detail Range 2}, 0), 3), ""), "")

hopefully I explained this well enough

Thank you

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!