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

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list