Status

[NewbieHere]

hi all,

i'll make this quick and simple. I would like to create a field (named status) that would display either the following:

"Unpaid"

"Paid"

I would like to make this into a calculation field, so that if a specific field is not filled out, field status will return either "paid" or "unpaid"

thanxs

[comment]

Quick and simple it is. Status (calculation, result is text) =

Case ( IsEmpty ( specific field ) ; "Unpaid" ; "Paid" )

[NewbieHere]

Okay that was easier then i thought. thanxs

but another question to add:

is there anyway to get "unpaid" in red text and "paid" in green?

[Slobey]

case( isempty(specific field);TextColor ("unpaid";RGB (255;0;0));TextColor ("paid";RGB (0;255;0)))