2 Replies Latest reply: Aug 28, 2015 7:10 AM by Razor Ramon RSS

    Ignore selection from two fields in an if statement

      Hi,

       

      I have an if statement that I use to change the background colour of an expression in a table.

       

      The expression is as simple as

       

      if(monthstart(StartDate) <= monthstart(today()) or StartDate < 30, red())

       

      The expression works as expected, but I would like the expression to ignore a selection from two specific fields in my app as when a user makes selections on those fields, the colour expression doesn't work as expected.

       

      Can someone please let me know if it is possible to exclude selections in an if statement and how to do it if possible?

       

       

      Many thanks