I have a master tasks list that I would like to recreate every month into another table by clicking a button. I can make this work manually using Addrow but I thought it would be easier to be able to just add a row manually as we change the tasks in the list vs going into the button formula .
I was trying to reference an existing post but the formula does not quite work. Any suggestion on how to make this work or another formula that would work better?
LeftPad("",([Master Task List]-1),"|").Split("|").AddRow(Tasks,Tasks.Software,[Master Task List].Software,Tasks.Owner,[Master Task List].Owner,Tasks.Type,[Master Task List].Type,Tasks.Week,[Master Task List].Week)