If negative number then enter text


I would like to enter text in a cell if another cell has a negative number. Can I do this or do I have to specify a range of numbers?

If "H-Days between deadline complete" is a negative number then enter "Late" into "Late" column.

Thank you,


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!