Is it possible to convert the "4d" (identified as a text) in the "Duration" column to a number 4?
Best Answer
-
=VALUE(LEFT([Column5]@row, 1))
Replace [Column5]@row with whatever position the column is that you want to modify.
Answers
-
=VALUE(LEFT([Column5]@row, 1))
Replace [Column5]@row with whatever position the column is that you want to modify.
-
It works! Thanks!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!