Formula works in one sheet but not others (cross-refs are updated)

Options

Hi there,

I have a formula in one sheet, which looks at the task and calculates the dates for each task, excluding holidays and weekends.

=IFERROR(WORKDAY([Task Start Date]@row, VLOOKUP([Product Version]@row + Task@row, {ConcatProdTaskLookupDerek}, 2, false), {TechTarget Holidays Range 2}), "")

I then use this same formula in a different sheet, adjusting the reference to the same lookup columns with a different name:

=IFERROR(WORKDAY([Task Start Date]@row, VLOOKUP([Product Version]@row + Task@row, {ConcatProdTaskLookupJared}, 2, false), {TechTarget Holidays Range 2}), "")

Both references point to this:

The formula works as expected in the first sheet (Derek) but does not work at all on the second sheet (Jared). I can't figure out why. I tested both on the same list of tasks.

Derek's sheet has 2,103 rows and Jared's has 536. Any ideas?

Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!