Ignore selection from two fields in an if statement

[#1]

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

[jonathandienst · Accepted solution]

Possibly this:

if(monthstart(Only({<Field1=, Field2=>} StartDate)) <= monthstart(today()) or Only({<Field1=, Field2=>} StartDate) < 30, red())

(change Field1, Field2 to the correct fieldnames)

[#3]

Fantastic Jonathan.

Many thanks