anchor.diff:  
   The connector uses the following logic to process and convert Smartsheet data:
   
  -* **Text/Number**: The Text/Number column defaults to the majority rule. This means that numeric values are returned if more than half of the column inputs are numeric. All other values are discarded. This rule can be changed in the “Advanced Options” section during login.
  - 
  +* **Text/Number**: The Text/Number column defaults to the majority rule. This means that numeric values are returned if more than half of the column inputs are numeric. All other values are discarded. This rule can be changed in the [Advanced Options](#advanced-options-menu) section during login.
  +
   * **Date, time**, and **datetime**: Date, time, and datetime columns have a storage class of TEXT, which means they are not converted to a date until a query is ran.
    
   * **Picklists**: Picklists probe for types but they use a precise rule (100%). So, one text string in a list of integers would cause the picklist to display text. All of the state picklists resolve to text (5-State Signal, 6-State Hearts, etc..).
  
positive.code:  
  **Data retrieval mode has 3 options:**
  
  <aside class="notice">The "Data retrieval mode" section only applies to Text/Number columns</aside>
   
  * Always return text - returns all results as text
  * Use “majority” rule - returns numeric results only if more than half the column inputs are numeric, discarding all non-numeric input
  * Use “entirety” rule - returns numeric results only if 100% of the column inputs are numeric, otherwise returns all results as text
   
  **The SQL table names section is available to shorten names. By default the full path is appended to the sheet name. Unchecking this option will cause only the sheet/report name to be returned.**
  
  # Custom SQL Functions (optional)
  
  In the Advanced Options menu, scroll down to the bottom of the “Optional content” list and you will see an “Enable custom SQL functions” checkbox:
  
  <img src="images/Screenshots/customsqlfunctions.png" /></br></br>
  
  
negative.code: 
  <img src="images/Spotfire/logIntoDsn.png" /></br></br>
  
  Select a Table and all columns needed, set a Data Source Name, then click **OK**:
  
  <img src="images/Spotfire/dataSourceName.png" /></br></br>
  
  Select the Data table you just set up and click **OK** to import the data (the Name will be the same as the **Data source name** you entered in the last step):
  
  <img src="images/Spotfire/finalizeDataSource.png" /></br></br>
  
  