Help needed with using VALUE function...

Allison S
Allison S ✭✭
edited 10/31/23 in Formulas and Functions

Hi All -

I'm needing to convert Text to Number as intermediate step for another formula column in my worksheet.

Have successfully used VALUE Function =VALUE(LEFT(Probability@row, 2))

This will work great until I get to 100%.... Help & advice welcome


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!