Symbols not Resulting from Formula

I am trying to do a three-way match of dollar amounts in 3 different cells.

I have the formula set to a column using the Yes, Hold, No Decisions symbols. Here is the formula:

=IF([Requisitioned Amount]@row <> [PO Amount]@row, "no", IF([PO Amount]@row <> [Invoice Amount]@row, "no", "yes"))

Two Challenges

1) My symbols are not appearing, despite choosing them.  I have the symbols working in other sheets and compared the formula, and I can't see where I've gone wrong. I'm sure I'm overlooking something obvious!


2) is there a way for me to write the formula so if the PO Amount, Requisitioned Amount or Invoice Amount are missing that the "Hold" symbol appears?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!