Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Importing Task Hierarchy from CSV file

✭✭
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!

Trending in Formulas and Functions