4 Replies Latest reply on Dec 11, 2017 1:17 PM by Teresa Wright

    IF Calculation with 2 Conditions

    Teresa Wright

      I am attempting to create a calculation that will return results if the "Days Left" field is less than 30 and the Status is not equal to "Approvals".  Is this possible in one calculation?  Or is it better to break into two?

       

      My initial calculation is working, but I'd prefer the KPI symbol to appear only for those projects that are not in the Approvals stage.  Thanks!

       

      screen shot 1.jpg