6 Replies Latest reply: Jan 9, 2015 2:18 PM by Marco Wedel RSS

    Using IF and OR

    Leo Catt

      Hi All,

      I have a list of Step status in records and I need to determine late and overdue.  this is what I have so far, but I get an error out.


      Any suggestions?




      =COUNT(IF([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime') or

      ( if([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime'),1)