I have three checkbox fields (Submitted, Approved and Rejected). I need to return a value based on which checkbox is checked. I can get it to work with the IF function separately, i cannot get it to deliver and value if two checkboxes are checked.

Example: If Submitted is checked, it returns the value of "Submitted". If both the submitted and approved checkboxes are checked i cannot get it to return the value of Approved.

=IF(Submitted@row=true, "Submitted", IF(Accepted@row=true,"Approved", IF(Cancelled@row=true, "Declined")))

I have tried AND / OR without success. Regardless of the order it always make the checkbox to the left the priority.

Any assistance would be greatly appreciated. Thanks