FIND formula not working
We have an line item composed of all the Sales Reps associated with an account (some only have 1, some have multiple). This line item is text formatted. This line items is called "Sales Reps"
We then have a second text-formatted line item, which is a text field, called "name," and the functionality we are looking for is when we type the name of the rep in the text field, our line item with the FIND formula in it will return the number of accounts that rep is associated with. Currently, the formula is only returning zeros, and we cannot figure out why.
The formula looks like this:
FIND(name, Sales Reps)
We know that the text syntax matters, and we used the Compare formula to verify that the model is recognizing the names match between line items when we input the name in the "name" line item.
I'm wondering if there is a consideration we are overlooking, as it appears in theory the formula should be working?