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@row-true copy Point Goal to Points Earned. I think this should be easy, but I have not been successful all day!

Andrea Westrich

Never mind, I finally figured it out,

Andrea Westrich

Never mind, I finally figured it out,

Nic Larsen

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

Andrea Westrich

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!