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

nevermind, figured it out :)
=IF(AND([Recommendation and Action Plans Complete]2 = 1, [Lessons Complete  Copy to Master]1 = 1), 1, 0)

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 dragfill 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
Answers

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

nevermind, figured it out :)
=IF(AND([Recommendation and Action Plans Complete]2 = 1, [Lessons Complete  Copy to Master]1 = 1), 1, 0)

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 dragfill 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

Perfect! Thankyou, i changed it to that.
Help Article Resources
Categories
Check out the Formula Handbook template!