Multiple checkboxes

hennarizvi

Hi there! I have two columns, for the sake of this example we can call them A and B.  I would like to create a formula so that if A and B are both checked off, it will show the text "Sent" but if only A is checked the text will say "Reviewing".  If neither checkboxes are marked I would like the text to read

"Pending". Can someone please help me out with this! Thanks!

 

Andrée Starå

Hi,

Try something like this.

=IF(AND(A@row = 0; B@row = 0); "Pending"; IF(AND(A@row = 1; B@row = 1); "Sent"; IF(A@row = 1; "Reviewing")))

The same version but with the below changes for your and others convenience.

=IF(AND(A@row = 0, B@row = 0), "Pending", IF(AND(A@row = 1, B@row = 1), "Sent", IF(A@row = 1, "Reviewing")))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

hennarizvi

This worked, thank you!

Andrée Starå

Excellent!

Happy to help!