#Invalid Data Type in INDEX Formula

I am trying to reference a State Abbreviation sheet that has one column the full state name in column 1 and the abbreviation in the column 2. Right now, my form populates the full state name in to my column: "Onsite/Worksite State" and I need it to populate just the abbreviation into a new column. When using the Index formula, I am receiving the error #Invalid Data Type -any help is appreciated on fixing this error

=INDEX([Onsite / Worksite State]@row, {State Abbreviations Range 1}, 2)

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!