Graphic Indicator for Text Field

O

Olive Oil

I have created a custom Enterprise Project Text Field. I want a graphic
indicator to appear when this field is not empty. In other words if there
are some words in this field I want the indicator to appear. If there is
nothing in the field, then no indicator. I have tried several different
formulas but nothing seems to be working. Can anyone help with a formula?

Thank you!
 
D

Dale Howard [MVP]

Olive Oil --

It would help if we knew what formula you included in the custom enterprise
Project text field. Are you absolutely certain that the formula generates
at least one text string in that field, and can also generate a null text
string ("") as well? Also, have you tried using the following criteria as
your last item on the list of Graphical Indicator criteria in the field:

Test Value(s) Image
equals "" graphical indicator

Let us know.
 
D

Denis Hathaway

In Graphical indicators definition, try Greater than and put a space in the
Value field. This should give you the selected symbol if the field is non
blank.

I tried setting test1 with the formula IIf([Text2]="Y",Name,"") and it
showed the symbol when Text2 was "Y" regardless of the task name. When
Text2 was anything except "Y" Text1 appeared empty.

Denis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top