Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Extract a number from the Left of a cell - HELP!
Good Day to ALL.
I am new to the vommunity and need some help....
I have a survey form for my clients and when the results are populate, I would like to tally the results - by client.
What I am looking to do is extract the number to the left of the survey response.
eg. 5 - Very Satisfied
4 - Somewhat satisfied
3 - Neutral
I only want the numeric values - "5,4,3" etc. and have them SUM in a separate cell...
Any help is greatly appreciated.