Sign in to join the conversation:
Does anyone know how do you split data in one cell into multiple columns?
Hi Stephanie,
Yes, but I need to have an example of how the data is structured.
Is it always the same structure?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
This discussion was created from comments split from: Can't Edit or Delete "Send as Attachment" Recurrence.
I'm the admin of a workspace which contains 2 sheets: 1) "Source Dropdown Sheet" which should function as master dropdown list to feed other sheets (sample a US State dropdown column), and 2) "Source Sheet 1" in which I'm attempting to link the State column to reduce copy/pasting. However, after going through the process…
Hi there. I am working on several sheets that have a column called "Hours" which holds an hour estimate for task rows. I'd like for their parent rows to have a sum like "=sum(children())" so I can see how many hours are estimated for each project. My problem is that while I can manually set this for the rows, these sheets…