Conditional field value based on whether a container field has been populated with a signature or not.
I've been working on a simple safety audit database and the list view to see a list of audits performed.
One of the fields in list view is name Status and is used to see if an audit has been reviewed or not. I have a signature container field named: Safety Department Signature. The status field should say "Unreviewed if the container field is empty, and say "Reviewed" if the container field has been populated. I used an if statement to try and accomplish this: If (IsEmpty ( Safety Department Signature ) ; Status="Unreviewed" ; Status="Reviewed"), which does not work as all it shows is a 1 or 0 in the status field. Any ideas where I went wrong, I know this should be very simple...