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.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Automated Workflow Question
Is there a way to set an automation so that all data from one month flows (based on the DATE column) flows to another sheet (archive) when a new month begins? Everything I find is either asking for a specific date OR talks about a weekly trigger which will not work.
Dashboards
I have a dashboard layed out with widgets and want to use it as "template" for new projects that come in. How do I do this? I tried copying it along with an updated metric sheet but all my links for the dashboard are for the previous project's metric sheet. I supposed I need to relink to the new metric sheet however when I…
Approval Automation in Bulk?
Is there a way to bulk send approval requests to a department head so they can review multiple requests through a single email? Current automation workflow appears to send individual email based on each submission. If a department head had multiple submissions 20-30, then they would receive that many emails. Is there a way…

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