Return a Blank in an Index Formula
I'm using an Index formula, =INDEX({T3DP V4 - Project Schedule Range 2}, MATCH([Release Version]@row, {T3DP V4 - Project Schedule Range 1}, 0), "") and want to return a blank response if there is no value in the [Release Version]@row. I keep getting a "#INVALID DATA TYPE" message.
Thank you,
Kim
Answers
-
HI @kimberlee.adam89166 ,
Try this:
=IFERROR(INDEX({T3DP V4 - Project Schedule Range 2}, MATCH([Release Version]@row, {T3DP V4 - Project Schedule Range 1}, 0)), "")
Let me know if it works for you!
Best,
Heather
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!