When ZERO, Status change to YES

richard_uy

Hi,

When the Balance column equal to 0, how the Status column auto change to YES ?

Andrée Starå

Hi Richard,

Try something like this.

=IF(Balance@row = 0; "YES")

The same version but with the below changes for your and others convenience.

=IF(Balance@row = 0, "YES")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

richard_uy

Hi Andree, there're two column..

richard_uy

It works perfectly.. thanks Andree.

Andrée Starå

Excellent!

Happy to help!