copying a row twice and giving each row a unique identifyer
Hi I have a created an audit form that can have 2 action items. To control each action item individually, I want to copy the row to a separate sheet with a unique identifyer. I'm able to copy the row 2 times based on a workflow condition. the copied rows are identical twins. Because both action information is in one row I need to remove the information of the first action to prevent the user to be confused. i have tried it with formulas but because I don't have a unique identifier I can't separate the data. does anybody have a tip for me?
Help Article Resources
Check out the Formula Handbook template!