Flag setting

Tinka Louw

I need he flag to be activated when 2 conditions are met

E.g if there is a value in a column and no value in another column, the flag must show

Brent Wilson

Try something like this..

=IF(AND(ISBLANK([COLUMN1]@row),NOT(ISBLANK([COLUMN2]@row))),1,0)

You may have issues if you have formulas in cells as they may show as nonblank. In this case, you may want to use something more appropriate for the data like <0, or ISDATE...

The column where you put this formula must be a symbol with the flags turned on and 1 will cause the flag to show, and 0 will turn it off.