Formula works in one sheet but not others (crossrefs are updated)
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

And I figured it out — I neglected to define the second reference (holidays). D'oh!
Answers

And I figured it out — I neglected to define the second reference (holidays). D'oh!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!