Multiple IF statements

I am trying to get the following to happen, and i am newer to smartsheet so need some help please.

I need that if the checkbox in 'row 2' (and under based the amount of entries) is checked AND the Lessons Complete in the first row is starred, then the lessons complete in row 2 will automatically put a star in it.

Best Answers

  • Katie Mueller
    Katie Mueller ✭✭✭
    Answer ✓

    nevermind, figured it out :)

    =IF(AND([Recommendation and Action Plans Complete]2 = 1, [Lessons Complete - Copy to Master]1 = 1), 1, 0)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!