Saturday, October 27, 2018

Search to Display Shipping Address (exclude Company name) in one Column of Customers List

1. Navigate to Lists > Search > Saved Searches >  New
 -- Type= Customer

  A. Criteria > Standard:
   Stage=Customer
   Inactive=False
  B. Results
   Company Name
   Formula Text = in Formula column, kindly set Formula by clicking on small window to pop up and copy the formula below:
{shipaddress1} || ' ' || {shipaddress2} || ' ' || {shipaddress3} || ' ' || {shipcity} || ' ' || {shipstate} || ' ' || {shipcountry}
*You may add more columns as desired
2. Hit Set then Done
3. Click Save & Run

No comments:

Post a Comment