I am trying to extract the first letter.
Hi Community,
I need to extract the first letter from other cell. Please check the formula and help me.
Please help me to get the correct values, If 'e' represents in the duration column then it should be '7' else '5'
Thanks In Advance!
Cheers!!
Best Answers

Sorry, I was going off the formula in your screenshot instead of your description of your logic.
When using IF, the syntax is =IF(logical expression, value if true, value if false)
Just switch the places of the 5 and 7 so that 7 is the value if true and 5 is the value if false:
=IF(LEFT(Duration@row, 1) = "e", 7, 5)
(The links to the help pages for Smartsheet Functions and Formula Error Messages are in my signature below. I find it very handy to have these bookmarked.)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

That helps,
Thanks Jeff!!
Answers

@Shaik. Baru You're almost there. The CONTAINS function looks anywhere in the cell for the value you're searching for. So it's not quite right for this formula. What you're looking for is the LEFT function, which returns the leftmost characters of the text value in the cell you're referencing. The syntax is:
=LEFT(text value, number of characters to collect)
So for your formula, you would use:
=IF(LEFT(Duration@row, 1) = "e", "5", "7")
 I am assuming you want your values of 5 and 7 to be considered as text since you have them wrapped in quotes in your formula. If that's not the case, and you want to be able to use these for calculations, remove the quotes: =IF(LEFT(Duration@row, 1) = "e", 5, 7)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Thanks for your comment. i would like to appreciate your help on this. But unfortunately this is not working 100%. I would like to see, If any cell data starts with "e"(elapsed) then it should reflect 7, and cell data without "e" should reflect 5.
Thanks again!!
Shaik

Sorry, I was going off the formula in your screenshot instead of your description of your logic.
When using IF, the syntax is =IF(logical expression, value if true, value if false)
Just switch the places of the 5 and 7 so that 7 is the value if true and 5 is the value if false:
=IF(LEFT(Duration@row, 1) = "e", 7, 5)
(The links to the help pages for Smartsheet Functions and Formula Error Messages are in my signature below. I find it very handy to have these bookmarked.)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

That helps,
Thanks Jeff!!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!