How can I create an IF(AND formula with multiple check box columns

newtothis

I want to create a formula as below, I know this will more than likely be a large formula and that's ok! Almost all of these columns will be check boxes with the exception of 1!

So far I have:

=IF(Quote@row = 1, "AAV", (IF(AND(Quote@row = 1, EmailSent@row = 1, "AST")))

Now how can I add to the formula if a column isn't blank to return the value that is not a checkbox?

newtothis

I actually solved this myself! I created a helper column for the one column that was not a check box!

newtothis

I actually solved this myself! I created a helper column for the one column that was not a check box!

Marcela

Hi @newtothis!

Glad you worked it out! Thank you for sharing your solution!