Formula Help

Rachel Fretz

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

Contact Snip.JPG

Thanks!

Tags:

Formulas

0 ·

Best Answer

Michael Culley ✭✭✭✭✭

07/01/22 Answer ✓

=LEFT([Task Name],1)

1 · Share on Facebook Share on Twitter

Answers

Michael Culley ✭✭✭✭✭

07/01/22 Answer ✓

=LEFT([Task Name],1)

1 · Share on Facebook Share on Twitter
Rachel Fretz ✭✭

07/01/22

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

Thank you!

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Unable to Convert to Column Formula
Using this formula Smartsheet isn't letting me convert to a column formula: =[Material Received]@row - [Purchase Date]@row - [Lead Time (days)]@row
Multiple IF statements
Hello, I'm trying to make an IF( formula for the following criteria. If Tech is YES and Curved is YES, 650 If Tech is YES and Curved is NO, 500 If Tech is NO, 0 Thank you!
Sum amounts within certain year and type
Hi, I have a report listing payment (i) amounts for various (ii) items and the (iii) payment date in long date format. I am trying to sum all the amounts per year and per item. Example: SUMIFS(amount, type = "paint", year = "2023") Adding up all the values in "amount" column if the type column is "paint" and the "date"…