7 Replies Latest reply on Dec 7, 2017 10:15 AM by Jolon Sabo

    IF Then

    Jolon Sabo

      I have a list of separate dimensions that if they are "No" then I want to display a statement else display a blank.

       

      Example:

       

      Location 1:

       

      IF [Water line testing]  = 'No' THEN 'Water needs to be tested'

      Else ' '

       

      IF [Water in reservoirs] = 'No' THEN 'Need to put water in reservoirs'

      Else ' '

       

      I would like to display both statements on separate lines if they are both 'No'

       

      Output example:

       

      Location 1:

       

      Water needs to be tested

      Need to put water in reservoirs

       

      Any ideas?