Multiple checkboxes

hennarizvi ✭✭
edited 12/09/19 in Formulas and Functions

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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!