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.




      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?