Flag when a character is entered instead of a number =IF(NOT(ISNUMBER statement...

Hello,

I cannot figure out how to add in 2 other cost fields into this statement. My purpose is to have 1 check box (in a single column) enabled with a check mark, whenever one puts text into a field where we need only numbers. The field names are : Travel Cost, FTG Cost and HS Cost. Once I get this part done, I will then setup a notification back to the user to resubmit a new form using numbers.

I was able to get only 1 column to work, but I need to add 2 more. What is the formula, please and Thank you!

=IF(NOT(ISNUMBER([Travel Cost]@row)), 1)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!