Same data to reflect

Rakesh Lavishetty

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.

hours.jpg

Antonio Figueroa

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

Antonio Figueroa

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

and then in your cell add the total hours + "H"

Rakesh Lavishetty

Hi @Antonio Figueroa ,

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.

Antonio Figueroa

Please see the link below.

https://app.smartsheet.com/b/publish?EQBCT=2cd0a8604844452bb0db8f49780c8bb6

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.

Rakesh Lavishetty

Hi @Antonio Figueroa,

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.

screenshot23.jpg

Antonio Figueroa

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

Rakesh Lavishetty

Hi @Antonio Figueroa ,

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??/

Thanks in advance.

data 2.jpg

Antonio Figueroa

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

Rakesh Lavishetty

Hi @Antonio Figueroa ,

Thank you for your patience in writing to me.

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

thanks,

Rakesh.