Saved Search for a range of accounts

I am trying to find a way to select a range of accounts with out having to click on every account that I need to have information returned. I currently have 76 accounts that have a leading 9000-####.  I would like to be able to select a from  EG. account 9000-0001 to 9000-9999.

Is there an easy formula to do this?  or can you copy and paste a list of accounts into the search criteria with out keying all of the accounts

Thank you for any help with this.

Rookie Asked on October 21, 2019 in Saved Searches.
Add Comment
1 Answer(s)

Use  a formula numeric field at your criteria: TO_NUMBER({number}) then choose select between and choose your range.

Beginner Answered on October 21, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor