Is there a way to work with a list of values in a single cell?
My situation is: a form user enters a submission, that populates a single line in a smartsheet. Each submission may have any number of samples, each which has a value associated it with it. Currently, the form user enters the values on separate lines in the form field, so they end up as a list of values in a single cell. This is the format we'd like to use, because it works well for copying the data to external programs.
My question: could I make a column that doubles the values of the first column?
For example if the user enters: 2 4 2 5 2
The second column puts out: 4 8 4 10 5
I have not found a simple way to do this. I've tried a little to use hidden helper columns, however I don't think that would work as it needs to work for any number of values per line, and for all lines in the sheet.
I appreciate any help anyone could share. Thanks!