Same data to reflect

here I need to put hours column data in Description column as shown in screen shot,

Please suggest how to achieve this, Thanks in advance.

Regards,

Rakesh.


Best Answer

  • Antonio Figueroa
    Antonio Figueroa ✭✭✭✭✭✭
    Answer ✓

    I would make another Helper column and use =len

    to count the number of characters and then use a nested if statement.

    =if("new" Column =3, left(Column,2),if("New"Column = 4, Left(Column,3) and continue this for as large of a number you need

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!