1 Reply Latest reply on Sep 13, 2010 1:15 AM by sunmoonstar.13

    Labels

    JohnCompton

      Title

      Labels

      Post

      I am trying to limit printing of a label for a field that either has a date or is empty, if empty no label. I tried to make a calculation for the field label as a global field but failed.

      Since not everyone is married, "wedding anniversary" may be unfortunate. I am trying to make it only print that label if the field is not empty.

      This seems like something I used to be able to do but haven't for too long. Please help.

        • 1. Re: Labels
          sunmoonstar.13

          Apply Conditional Formatting to the text label. Set up the Conditional Formatting with a formula so that if the relevant field is empty, the text label is set with the same colour as the background fill colour, thereby making it "invisible".

           

          Nick