I want a blank cell to return a symbol in another cell

This is a pretty basic question that I'm sure has been asked before, but I'm having trouble finding an answer. I'm using the below formula, but I need to add an additional rule so that if the Loaded cell is blank, it would return the "Hold" symbol. I've tried some variations of ISBLANK, but haven't gotten any to work yet.

=IF(Loaded@row = "Yes", "Yes", IF(Loaded@row = "N/A", "No"))

Thanks in advance for any help!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!