2 Replies Latest reply on Dec 11, 2015 8:54 PM by littleluce

    Case statement required or similar

    ajayz

      Hi

       

      I have there check boxes:

       

      [CEOcheck] the checkbox is ticked using ( IsEmpty (CEOApproval); "No" ; "Yes" )

      [CFOcheck] the checkbox is ticked using ( IsEmpty (CFOApproval); "No" ; "Yes" )

      [COOcheck] the checkbox is ticked using  ( IsEmpty (COOApproval); "No" ; "Yes" )

       

      [CEOApproval] is a signature container 

      [CFOApproval] is a signature container

      [COOApproval] is a signature container

       

      Each CEO, CFO and COO signs using their iPhone.

       

      I need a way to indicate that all thee people have signed off the new staff member for payroll. I need a case or if formula that checks to see if EACH signature container or check box has been entered.  Only if all three have been completed then a checkbox called [completed] is ticked "yes" and then sends an email to Payroll.

       

      Thanks