Hi all,

I'm =
testing out whether I can use a table in org as a project status tracker.=
=A0 In col 6, I have the value of the project (e.g. 162.50) and in col 9, t=
he status (e.g. quoted, approved, invoiced, closed, etc.)

I would like to see, at a glance, what the value of quoted w=
ork is, so I'm currently doing this in col 12 (pasted from formula edit=
or):

# Column Formulas

$12 =3D if($9=3Dquoted,$6,0)

# Column Formulas

$12 =3D if($9=3Dquoted,$6,0)

( Col 9 in this instance contains "closed" and Col=
6 contains 162.50. )

This formula results in =
the text

=A0closed =3D quoted ? 162.5 : 0

=A0closed =3D quoted ? 162.5 : 0

being di=
splayed in col 12.=A0 However, in another row where the col 9 does have the=
text "quoted", I get pretty much the result I'm looking for,=
e.g. "400." will appear in col 12 where I have 400.00 in col 6.=
=A0

In the instance where the if test proves false, I would like a zero or = nothing appearing.=A0 The intention is to sum this column in a footer row.<= br>

In the instance where the if test proves false, I would like a zero or = nothing appearing.=A0 The intention is to sum this column in a footer row.<= br>

Thanks,

--

=A0 Steve