Task List from Cells
Hello! I am trying to create a task list based off of a smartsheet 'grid'. The cell that Has all the tasks in it is called 'Setup Needs' and just has a list of different needs. But the problem is, these are all separate tasks that need to be done. So I was trying to make a task list that had on one line "(6) 6ft tables" and then the next task would be "(10) 72" Rounds - (8) Conibear wood + (2) plastic" and so on. Is there a way I can code this in? I.e. separate the cell text?
Answers
-
How many rows of data have data like this?
My gut tells me that you will be better served to just make subtasks for each row via long hand re-entry and manage via the card view.
There probably is a way to break the tasks out by using mid and find searches looking for the carriage return (CHAR10) but the rows where there is a second "intended" list is going to make that very difficult to accomplish. And, even if you were successful, it will still only transcribe those tasks in a different field in the same row, not into different rows.
Within card view you can enable subtasks and they are very easy to populate with things like this.
Sorry I couldn't get you a silver bullet answer.
Hudson
