If checkbox is check, copy cell to another
Andrea Westrich
✭✭✭✭✭✭
I have the following columns:
Complete  Checkbox
Point Goal  Number
Points Earned
I'm trying to write a formula that says if Complete@rowtrue copy Point Goal to Points Earned. I think this should be easy, but I have not been successful all day!
Best Answer

Never mind, I finally figured it out,
Answers

Never mind, I finally figured it out,

Place formula in Points Earned column: =IF([Complete]@row = 1, [Point Goal]@row)

Thanks, @Nic Larsen, simple right? This is what I tried that and unfortunately, it did not work.
This is what worked: =IF(Complete@row = true, [Point Goal]@row, "")
But thank you so much!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!