# Same data to reflect

Options

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

Regards,

Rakesh.

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

I would use a helper column and use the =left() formula to extract the actual value of the hours.

• Options

Thanks for your time to writing in me,

I have tried as you suggested but showing invalid operation.

Could you please suggest another formula to achieve this?

Thanks,

Rakesh.

• ✭✭✭✭✭✭
Options

This is the sheet I made. Please let me know if this works for you and also let me know when you are done with the sheet so I can delete it.

• Options

I have gone through the sheet which you have made, looks like information you have erased or modified before I have seen, I m attaching screenshot which I could see in the sheet.

Please include the previous data one more time, it would be helpful for me if it works.

Thanks,

Rakesh.

• ✭✭✭✭✭✭
Options

Okay it is back. Change data in the last column and the other two columns will update.

• edited 03/18/21
Options

The data in the sheet with formulas are working fine,

here number 2 shown in the formula represents the numbers of values in column, but here some times my data exceeds to 3 digits.

EX: if i apply same formula to 189h it is taking 18 only

and if i apply formula for 9h it is showing invalid.

can we make more dynamic here??/

• ✭✭✭✭✭✭
Options

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

• Options

Thank you for your patience in writing to me.

The formula which you have suggested absolutely working fine for me.

thanks,

Rakesh.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!