Looking to create a formula that will show the status of requesting copy. I’d like it to cover the 3 fields I have (all checkboxes) so when a team is done providing a component of copy, they check the box and the status appears.
Field 1: Copy Requested Checkbox
Field 2: Ready for QA Checkbox
Field 3: QA Approved Checkbox
Hoping the formula can mirror this:
IF Copy Requested is checked then the Status is Copy Requested
IF Ready For QA is checked then the Status is Ready for QA
IF QA Approved is checked then the Status is QA Approved
I have it figured out with just one field in the formula, but to add multiple is where I’m getting stuck.
Thank you in advance!