Views:

A smartlist that is created from a view could provide inaccurate results if the columns in the view are not selected in the same order as in the view.  For instance, The Employees smartlist is based off a view.  If you add the Federal Filing Status to the smartlist, incorrect results will appear, such as all employees with EXEMPT as the filing status.  If a new smartlist is created from the UPR00300 table and the filing status is added, correct results are returned.  This issue can also affect the results that are exported to excel.  I created a new Smartlist based off the Employees View and this showed correctly when the columns are in order with the View when adding the columns. Even when I add the column through the Smartlist Options window, it does not align right.