2 Replies Latest reply on Mar 30, 2012 4:38 PM by JamesMcPherson_1

    How To Calculate For A Result Based Off Two Other Field Criteria.

    JamesMcPherson_1

      Title

      How To Calculate For A Result Based Off Two Other Field Criteria.

      Post

       I am trying to have a Field Result to occur based on the criteria from two other fields.  I keep getting too few parameters.

      What I am trying to do example:

      Mail Swap 30=

      If(Status = "Mail Swap") and If(GetAsNumber(Modified Date) ≤ Get(CurrentDate) + 30); "30"; "No"