11 Replies Latest reply on Jul 20, 2018 9:39 AM by Jessica Wren

    Creating an IF statement

    Jessica Wren

      Hello, I am working on a project that contains application names, server names, and if that server is protected/ unprotected.

      A lot of applications have multiple servers. If one server is unprotected, the whole application is considered unprotected.

      Example: Application XYZ has 10 servers. 9 servers are protected, 1 is unprotected. Therefore, Application XYZ is unprotected.

       

      How do I create a calculated field that says the application is unprotected.

       

      I have been trying things like

       

      IF server contains ([protectionstatus], "Not Protected")

      THEN application = "Not Protected"

      END

       

      I am not allowed to post the excel sheet because it confidential to my work, but I can make fake one if necessary.