Formula Help

Rachel Fretz ✭✭

07/01/22 in Formulas and Functions

Is there a formula to pull the first letter of cell contents? I'm wanting to populate the "Subcategory" column automatically instead of manually

Thanks!

Tags:

• Formulas

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Michael Culley ✭✭✭✭✭

  07/01/22 Answer ✓

  =LEFT([Task Name],1)

  1 · Share on FacebookShare on Twitter

Answers

• 

  Michael Culley ✭✭✭✭✭

  07/01/22 Answer ✓

  =LEFT([Task Name],1)

  1 · Share on FacebookShare on Twitter
• 

  Rachel Fretz ✭✭

  07/01/22

  https://community.smartsheet.com/discussion/comment/335057#Comment_335057

  Thank you!

  0 · Share on FacebookShare on Twitter

Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list