Formula to get first name from 2 formats either (Lastname, First) or (Firstname Last) formats.
Category: TRIM
CamelCase to Camel Case
Here is a good practice for combining functions to get a full smartsheet It basically add a space before any capital letter in a text, helpful when you have strings without spaces and want to convert them. It is all in formulas. Put additional spaces before any upper case letter. made specially for custom request….