Combining formulas

Tina
Tina ✭✭✭✭
in Formulas and Functions

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!

· Share on FacebookShare on Twitter

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.

    · Share on FacebookShare on Twitter

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.

    · Share on FacebookShare on Twitter
  • Tina
    Tina ✭✭✭✭

    Thank you! It works perfectly.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!