How to pull data from another sheet?

Options

The formula I tried is:

=IFERROR(IFERROR(INDEX(COLLECT({Master DPS Directory Range 1}, {Master DPS Directory Range 2}, First@row, {Master DPS Directory Range 3}, Last@row), 1), INDEX(COLLECT({Master DPS Directory Range 1}, {Master DPS Directory Range 5}, DNumber@row), 1)), "")


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!