I am creating a hour tracker for my instructors (around 70 of them). I have a requirement in which I show how many hours they taught each month. In table 1 (Instructor Hours) I have everyone listed, with a formula field for total hours to date and each month through 2024.
In table 2 I have a form to push updates to table 1, however the form I'm using just seems to replace the current number in table 1 for each month instead of adding them up. Should I do a rollup linking to the update field that way, just tired of bashing my head against the wall trying to figure this out, any help would be appreciated. Thank you!
