Combining formulas

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

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, [email protected], 1), 1)

=IF(AND([Key Activity]@row, 1, [email protected], 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[email protected] ✭✭✭✭✭
    Accepted Answer

    =if([Key Activity]@row,if(or([CEC Tech]@row,[Corp iT]@row,[email protected],[email protected],[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

Sign In or Register to comment.