INDEX No Match Issue
Hello,
I have set-up a Smartsheet that links to another Smartsheet through INDEX matching. I use the same formulas for multiple drop-down selections that work properly on most but not on two of the selections. Do you have any recommendations to fix this issue?
Answers
-
Hi @Fiona Murray the #NO MATCH error is displayed when it can't find your Staffing Type on your other sheet. Can you double check the spelling on both sheets to make sure it exists on the other sheet?
-
Hi Ryan, thanks that worked! Looks like I updated the names on one sheet but not the other. :)
-
@Fiona Murray ah yes! Glad you found it 😀
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!