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"



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