I am trying to have a button where when clicked, it will add rows to a table with the data from 2 columns on another table. The Task Column is currently being added with the button using the formula pictured. However, I’m also trying to get it to populate the Stage column that matches the task from that same table as well. I cannot figure out how to add multiple columns from another table. Help Please!!!
I have a table with the tasks and stages as a template.
I have another table with the tasks from the template table (which is where I’m wanting to pull the stage in from) but it has more information as well (that I have a different view set up for) such as which employee is assigned to it and adding due dates etc. I’m tracking each line item per employee for onboarding purposes but I don’t see another way to accomplish it.