Smartsheet Help

Brian Lee

Good morning!

I am trying to figure out the problem with this formula. I have two sheets and I want one sheet to communciate with the other. The example is that in the first sheet if the ship has IRP formatting as new then in the second sheet it would mark the ship with a checkmark.

Below is the formula:

IF(AND({SHIP NAME}1=[Ship Name]@row, {IRP Formatting} 1 = "New"), 1, 0)

heyjay

This {SHIP NAME}1=[Ship Name]@row and {IRP Formatting} 1 = "New" . The 1 after the reference is out of place.