Sign in to Community
Sign in to view all badges
Expand my Community achievements bar.
I am trying to build a time card PDF. In this sheet, I want to add a date in one block and have the form calculate and populate additional fields based off of this one field/
example: I enter todays date in block 1 and then the form automatically calculates and populates the ending date of the time card in block 2 and then populates the range of dates for blocks 3 - 17.
Also, when I enter this date in block 1 on the first form, I want each form after that to mirror the initial entry with the same calculations.
example: I enter todays date in block 1 on form 1, the remaining 13 forms automatically enter the same info.