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 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
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 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
-
Perfect! Thankyou, i changed it to that.
Help Article Resources
Categories
Check out the Formula Handbook template!