If negative number then enter text

Options

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,

Chelsea

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!