ajayz

Case statement required or similar

Discussion created by ajayz on Dec 11, 2015
Latest reply on Dec 11, 2015 by littleluce

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

Outcomes