Auto move a row to become a child row?

Rob Barker · 08/05/21

I have set up my own annual leave system using Smartsheet and the approval workflow. The employee has to complete a form which then inputs the data for their line manager to approve or decline.

However all entry's are added at the bottom of the sheet and then above them are master(parent) rows with children under them with all the entrys/requested recorded. The parent row has the employees name and calculate time requested versus time remaining to take.

Can I automate the movement of new entry's to become a child of the parent row when submitted instead of having to manually move them on a daily basis? I thought based on the requester i could automate it but cannot find any way to achieve this.

Any help would be appreciated.

Thanks in advance

Rob

Andrée Starå · 08/05/21

Hi @Rob Barker

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Here's a possible workaround or workarounds

It might be possible to use the Smartsheet API

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå · 08/05/21