Flags

Tinka Louw

I need help with automatic changing of the FLAG symbol.

I want to change the flag color to Red if another specific column is blank and White if there is something the column (the other column is not a value column)

Matthew LeMasonry

Hi Tinka,

Try this formula:

=IF(Column@row = "", 0, 1)

Kind regards,

Matthew

Matthew LeMasonry

Hi Tinka,

Try this formula:

=IF(Column@row = "", 0, 1)

Kind regards,

Matthew

Tinka Louw

Thx for formula

I need another flag where there 2 conditions are met

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

Matthew LeMasonry

Hi Tinka,

Something like this should work for you:

=IF(AND(Column@row = "", Column2@row = >1), 0, 1)

Cheers,

Matthew