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

newtothis
newtothis ✭✭
edited 03/20/24 in Formulas and Functions

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?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!