
Good Value!

Sometimes you might look at your data and *think* you can see a number, but when you come to use it in a formula it doesn’t do what you expect. 😭
See the screen shot below, where the A+B column is putting the two text values together instead of seeing them as numbers and summing them.
You can use the VALUE() function within a formula to ensure that your formula treats the arguments involved as numeric data.
So the same formula =A@row + B@row with the Value() function surrounding each cell reference returns a different answer.
Here is Smartsheets help article on this useful function. https://lnkd.in/ej2__Dxd












