Auto move a row to become a child row?
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
Help Article Resources
Check out the Formula Handbook template!