Using result from one check box to check another box

The trigger box is a checkmark, the receiving box is a star. I'm using this formula:

=IF ([ShipC Updated]@row = 1), 1

The column name is ShipC Updated, the column I'm putting the formula in is Complete (has the star). I'm getting #Unparsable errors regardless of what I try! Please help!! Snip of spreadsheet below. Both columns are checkbox columns.

Thank you!!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!