What formula would I use to pull text into a new column?

Options

I want to use a formula to isolate the training type into a single column. Currently, "Training Type" is a primary column so I am unable to make it a dropdown selection and automation would take too long to do (there are over 100 rows). So I want to use a formula to isolate the training type from the "Business Segment, RCM Segment, Training Type" column. I initially tried:

=IF([Business Segment, RCM Segment, Training Type]@row = "NewHire", "New Hire")

That didn't work and even switched the = to contains and that didn't work either. As you can tell there are numerous different types of training types and I want to be able to include them all in a single column formula. Any help is greatly appreciated!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!