If and Index Match

emmawallace24
emmawallace24 ✭✭
edited 10/18/23 in Formulas and Functions

Hi, I'm trying to use an If statement in my index match formula to skip rows that are pulling from a blank to not overwrite them. I want to skip over pulling from the blank demand ID rows and not overwrite the SubTower row. The below formula doesn't work, should I be using IFERROR function?


=IF(ISBLANK([Demand ID]@row, " ",INDEX({SubTower}, MATCH([Demand ID]@row, {Demand Sort}, 0)), "")))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!