Multiple IF statements

Katie Mueller

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.

Katie Mueller

nevermind, figured it out :)

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

Genevieve P.

Hi Katie,

I'm glad you sorted it out!

One small recommendation I have is to add an "Absolute Reference" for when you're looking for the star (so the formula will always look in row 1), and updating your row reference for the current row to be @row. This way you can drag-fill the formula and it will stay the same:

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

Here's some information on both of these functions: @row function / Absolute References

Katie Mueller

this is what i have but it isnt working

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

Katie Mueller

nevermind, figured it out :)

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

Genevieve P.

Hi Katie,

I'm glad you sorted it out!

One small recommendation I have is to add an "Absolute Reference" for when you're looking for the star (so the formula will always look in row 1), and updating your row reference for the current row to be @row. This way you can drag-fill the formula and it will stay the same:

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

Here's some information on both of these functions: @row function / Absolute References

Katie Mueller

Perfect! Thankyou, i changed it to that.