Combining formulas

Hi,

I need some help with a formula. I have a one check mark column that I would like to 'check' if any of the following formulas are true. Can I combine them into one large formula?

=IF(AND([Key Activity]@row, 1, [CEC Tech]@row, 1), 1)

=IF(AND([Key Activity]@row, 1, [Corp iT]@row, 1), 1)

=IF(AND([Key Activity]@row, 1, Digital@row, 1), 1)

=IF(AND([Key Activity]@row, 1, Loyalty@row, 1), 1)

=IF(AND([Key Activity]@row, 1, [L+D]@row, 1), 1)


I would appreciate any assistance that you can offer.

Thank you!

Best Answer

  • L_123
    L_123 ✭✭✭✭✭✭
    Answer ✓

    =if([Key Activity]@row,if(or([CEC Tech]@row,[Corp iT]@row,Digital@row,Loyalty@row,[L+D]@row),1

    I think that should do it. you might be able to get it shorter depending on how the sheet is organized, but I can't tell without seeing the sheet. If you want to try you can post a picture of the sheet blurring out any personal info and I would be happy to try.

Answers

  • L_123
    L_123 ✭✭✭✭✭✭
    Answer ✓

    =if([Key Activity]@row,if(or([CEC Tech]@row,[Corp iT]@row,Digital@row,Loyalty@row,[L+D]@row),1

    I think that should do it. you might be able to get it shorter depending on how the sheet is organized, but I can't tell without seeing the sheet. If you want to try you can post a picture of the sheet blurring out any personal info and I would be happy to try.

  • Tina
    Tina ✭✭✭✭

    Thank you! It works perfectly.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!