If blank, populate cell, if not blank then ignore.

Can't quite complete this formula. I want the formula cell to copy the "Company name" if true (the box is checked), but I want it to remain what it is, if false (not checked). But I get an "Invalid column value" error. Maybe an IF and IsBlank combination? I can't get that to work either.

=IF([Ship to info the same as Bill to?]@row, [Company Name]@row, [Ship to info the same as Bill to?]1)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!