Parent/Child Relationship when importing from Excel

Jillian Powell

Jillian Powell ✭✭✭

08/15/23 in Smartsheet Basics

When we import Excel workplans into SmartSheet, we lose the parent/child relationship of tasks that were created through indenting.

I have played around with formulas/conditional formatting to automate but have not been successful.

Does this require using custom code?

Thank you!

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

08/16/23

Yes. You will need the API to get the hierarchy to pull over.

Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

MS Project Import Question
Hello all! I did a search, but can't find this exact situation in the community. I'm currently creating and updating a schedule in MS Projects and then importing it into Smartsheet. I've found that when I'm in the schedule in Smartsheet, select "import" and choose the MS Project file, it seems to create an entirely new…
Card View: Can't sort by desired category
I would like to use card view for one of my sheets - and sort it by the "type of service" that was performed on our equipment. For some reason, I am able to sort my cards by literally every category but that one. The column is a drop down menu. Is that the reason I am unable to sort by that category? Not sure why I…
Selection Committee Ratings
Hello: We are going to have a selection committee of 4 that will be reviewing 5 candidates based on pre-established criteria. The selection committee will submit their reviews through a Smartsheet form (unless you think a different method is better). There will be a total of 20 reviews: 5 candidates x 4 reviewers in the…

Help shape the future of Smartsheet.
Share your ideas and feature requests.