Moving latest entry into a new sheet
Would be great help if someone can suggest a solution to my below queries.
Here is my scenario: I am collecting many column data through forms. Once in 2 weeks I collect status from project team so that I can share latest update to my leadership team.
- Is it possible to fill in already available row data into forms and share the forms project teams to update only required info?
- If possible, there will be a duplicate entry in my sheet as I believe there is no option to update the sheet. so I want to move the project wise latest row into a new sheet so that updated row show in my dashboard. For example, I have Task_Name as project name and created date (latest date) this might be combination for my formula. I want to move only new entry new sheet.
Thanks in advance and hope my question are clear, if you can suggest any other approach would be really helpful.
Help Article Resources
Check out the Formula Handbook template!