Smartsheet Help

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)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!