Need a space saving IF OR formula

I have a working function to assign a school county to a new entry when a certain institution ID is put into the column. My issue, however, is the complete equation to accomplish this is too long and doesn't fit the last few school districts. I'm checking to see if there is a more elegant way to accomplish this so I can reduce the equation and fit all the districts.

Here it is with just 2 districts:

=IF(OR([Inst ID]@row = 1894, [Inst ID]@row = 1895, [Inst ID]@row = 1896, [Inst ID]@row = 1897), "Baker") + CHAR(10) + IF(OR([Inst ID]@row = 1899, [Inst ID]@row = 1901, [Inst ID]@row = 1898, [Inst ID]@row = 1900), "Benton")

So essentially, if the institution ID is 1894, 1895, 1896 or 1897 the district should be assigned to Baker county, and if the institution ID is 1899, 1901, 1898, or 1900 they should be assigned as Benton county. Again, this functions how it should, but there are too many characters for all the districts to fit in the same column formula. Is there a way to make the formula work so that [InstID@row = doesn't have to be repeated so much?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!