New Ticket Existing and Public Tickets   
Ticket:  409  Created: 8/6/2015 12:00 AM
Status:    Assigned:      
Lean Application / Version:
Priority:       Due Date:  
Name:   Invesco Houston USA    
Email:   -
Phone:    Estimate Hours:  
  Start:    Complete:  

Visible to Requestor Comment User Time
Select Advised client by email, awaiting response on resolved status. Lean Software 8/10/2015 4:56:25 PM
Select We think if we could see a task XML file to understand fully if possible to email to However - as an initial suggestion - place the SQL lookup on column F rather than the work column, then select the lookup 'Error if not in list' this should have the desired effect highlighting the cell red by default. We want to make sure however that we have no bug to fix. It seems your formula only compares to the selected option in the list, but perhaps your lookup SQL uses column F in the SQL query. As I say a task file (minus connection info if you like) would help us. Anything you send us will be destroyed once we close the call. Lean Software 8/7/2015 11:38:55 AM
Select Good evening, we are checking this for your now, please bear with us a short while. Lean Software 8/6/2015 6:02:19 PM
Select I'm trying to do conditional formatting / Excel Validation on a field. I want to highlight the field if the value in the first column (F) isn't in a certain list. What I've done is set up a work column (Y), I've created a SQL lookup in that column to create the list. On Column F, I have a formula for conditional formatting to set the cell blue if its value is not in the list (Y) =IF($F3<>"",IF($Y3<>"X",TRUE)) This works. However, for the Excel Validation (to create the alert message to the user), I use the same formula, but the checkbox to "Show error alert" will not stay checked, and does not seem to fire.though the "Excel Validation" button stays green. Thanks Invesco Houston USA 8/6/2015 5:57:34 PM


Skip Navigation Links.
Bug report
Expand DatabaseDatabase
Feature request
Help request