Reports pulling from formulas

I have reports calculating off multiple workflow sheets based on a column in the worksheet with formulas - the reports sometimes appear blank and when I go into the worksheet to see why, the formula column shows as blank and then reappears - almost like they only recalculate when looking at the sheet. the fomula is a nested vlookup within an if statement based off of a contact cell - is there anything that would cause this issue?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!