Probelm with IF(Contains formula

So I have a sheet where different fellows enter their budget through a form.
I am trying to copy the budget from a certain fellow in the T&E Descritionary column on the basis of the submitter's BIN Number.

The formula I am using is
=IF(CONTAINS("507777", [Employee BIN]@row), [Fellow 2 $ Share]@row, IF(CONTAINS("507753", [Employee BIN]@row), [Fellow 2 $ Share]@row, [Fellow 3 $ Share]@row))

So when the BIN number is 507777 or 507753 it should copy the Fellow 2 $ Share
But it is copying Fellow 3 $ share regardless.

When I tried changing the formula based on the Employer Name and not BIN it's working fine.
=IF(CONTAINS("Jung Seo", [Employee Name]@row), [Fellow 2 $ Share]@row, IF(CONTAINS("Shaliyah Sledge", [Employee Name]@row), [Fellow 2 $ Share]@row, [Fellow 3 $ Share]@row))
But I want to use something other than the Name as there can be consistency issues.

I feel that it has to do something with "Numbers vs Digits"

What am I doing wrong here?
Any help is appreciated.

Thanks

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!