topic Re: column values dependent on another column in Discussions

column values dependent on another column

ks_SES — Mon, 03 Feb 2020 16:13:06 GMT

Hi, I have two columns, and I hope the values of column 2 will depend on column 1 through a kind of Boolean control.

For example, I need the column 2 below to be automatically filled:

if Column 1>0, then Column 2 in the same row becomes filled with 3.

if Column 1<0, then Column 2 in the same row becomes filled with 0.

Thanks a lot!

Mark_Bailey — Mon, 03 Feb 2020 17:49:17 GMT

You can use a formula in Column 2 based on this expression:

If( :Column 1 > 0, 3, 0 )

You can copy it here, open the Formula Editor for Column 2, and paste it.

ks_SES — Mon, 03 Feb 2020 18:56:07 GMT

Thanks! It works.