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

Options

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.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!