I want to build a function that duplicates the row
If you organized a view properly, you could probably get things filtered for easy copy/pasting. For example, you could (1) make a new view that’s filtered by only the values that need to repeat, (2) select them all, (3) then click the plus icon for a new row, and (4) paste what’s on your clipboard. It might help to paste the values to an external sheet first though so you can adjust any values you need to. Or you could use another view that is filtered for recently added records.
Maybe someone else has an ideas on how you could reorganize your base so that you can leverage formulas, but I haven’t thought of any. Stay healthy to you too.