I'm attempting to allow the users to copy their time sheet records from one week to the next as a means to pre-populate their time sheets. At this time, I have my automation create a new record and copy the Related Project and the Related Employee successfully. However, there is a Formula Date Field called "+7 days" that takes the time sheet Date field and adds 7 days to it. When I try to have this "+7 Days" date copied over to the new record Date field, it comes in blank. Not sure how to get the automation to populate the Date field with this future date as intended.