Forum Discussion
Why is my formula not working correctly
I have used a formula to find items over $1,000 and not in a session and while it finds some items correctly its still finding items that are on the sessions and still displaying as not on a session....
The data from the ACH tab and Sessions tab are both copied from another application and pasted. Is there a specific way i should be coping and pasting this information to avoid the hidden characters?
When you can the text to column it removed any preceding zeros in an invoice number which will also make the same mistake because the data on the other tabs should have the preceding zeros.