Formula returning random data

maineL ✭✭✭
edited 06/29/23 in Formulas and Functions

I have a list of 7 courses and with each course comes specific data.The Tuition Type and SHP Item Type numbers are specific to each course. In this screenshot below, I have the courses in a dropdown list and hoping to populate the SHP Items Type and the Tuition Type columns with their corresponding data. It works for many columns, but for others, it's bringing back data, but not for the correct courses. The formulas I have set up for each are:

SHP: =INDEX({Data SHPType}, MATCH(Course@row, ({Data Course})))

Tuition: =INDEX({Data TuitionType}, MATCH(Course@row, ({Data Course})))

Any ideas? I have MANY different formulas going in this document, but I'm trying to do them one at a time to be sure they're working before moving on. Thank you!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!