Remove a string of characters after a special charater :


Need a formula to remove "Account name" from the Use case name. Right now the format in the use case column is Account Name: Use case Name

I want the "use case column" to only have the use case.

I tried the below formula but getting a circular reference error. Please advice. Thank you.

=LEFT([Use case: Name]@row + ":", FIND(":", [Use case: Name]@row + ":") - 1)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!