Importing Task Hierarchy from CSV file

Roger Mark
Roger Mark โœญโœญ
edited 12/09/19 in Formulas and Functions

We are looking to establish a daily import of our project portfolio into SS via a CSV file. ย When I look at the task import schema, I cannot see a way for SS to identify the parent and child relationships between the tasks. ย This means we cannot import nested tasks and the task hierarchy.

ย 

Do you know if there is a field and values we can set in the CSV that SS can read toย reinstate the parent-child hierarchy, either by means of a function we can run / automate, or better during import?

ย 

Many thanks for your help. ย 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!