I need a formula to return a value in column B, if column A has some random number.


In the below example: Column A has some random numbers and i need a value "Test" to be displayed, if column A has a number, otherwise it should be blank incase if there is no value in Column A. I need a formula to create this.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!