Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Rollup or Lookup for all instances of past data?

83 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey everyone!

I’m trying to pull the data from each of these columns into another table. I need them to be transferred as they are currently sorted and separated by a comma.

image

Example:

Week 1 should be first

24, 67, 45, 68, 599, 3358, etc. etc.

Any idea how to do this?

1 Reply 1

Alright, so I figured it out through an automation.

image

BUTTTT, now the issue I’m having is the program I’m trying to run this through is reading every single character as a separate item in an array - that’s causing me some serious issues (especially when we get into the big 4-5 digit numbers in the list)

Sooo, I think a workaround would be to parse every number separated by a comma and a space into a “single select” column, but I can’t figure out the automation to make this happen.

Any ideas?