Index/Collect Formula Error

Hi,

I am receiving the error "#INVALID VALUE" on only the first row of my data and wondering if someone could help with where I went wrong in my formula?

=INDEX(COLLECT({2021 KPI Scores Range 1}, {2021 KPI Scores Range 3}, @cell = [KPI #]@row, {2021 KPI Scores Range 4}, @cell = Region@row, {2021 KPI Scores Range 2}, "Q1-2021"), 1)

I am trying to pull in the value in the "Actual" column into the "Q1" column in yellow where "KPI#" AND "Region" are the same in both sheets and where Period "Q1-2021".

Thank you!


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!