#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
-
You need an INDEX/MATCH.
=INDEX({Column You Want To Pull OVer}, MATCH([Column To Match On]@row, {Column To Match In}, 0))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!