V Lookup formula for importing Contact List broke and I don't know why.

So I have a reference sheet of contacts and their assignments. I made a different sheet to assign tasks as they come in and set up an equation to look up and auto assign.

It looks like:

=VLOOKUP([Rule Number]@row, {Committee Range}, 2, false)

So when a task came in and it matched the rule, it would assign the person in the Committee sheet in column 2.

Before it was working, importing the same contact list format (with the colored circle, initials, etc) just fine. But I saved it, came back after my boss asked me to make a change, and all the contacts are plain text. I can't change it back. I tried the same format on a different sheet and the same thing happens. I ended up making a new column and matching current assignments up but I would like for the contact list to transfer so I can set up a notification for people when they are assigned a number as tasks come in and sort by card view.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!