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
-
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
-
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"
-
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.
-
Please see the link below.
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.
-
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.
-
Okay it is back. Change data in the last column and the other two columns will update.
-
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.
-
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
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!