Goal - Input latest related initiative date

Within a goal, I have create a custom date field. I would like for there to be automation to input the latest initiative end date into the custom date goal field.

Aha Pic.png

Aha Pic.png

Open full size

Aha Pic.png

• ADMIN RESPONSE

  Apr 10, 2023

  You can accomplish this today by creating a custom worksheet field on the goal layout: Aha! Roadmaps | Custom worksheets (Enterprise+)

  When you add the worksheet field, you will want to select your desired date format as the type:

  

  Here is the formula you can use to calculate: max(self.initiatives[].end_date)

  

  image.png

  image.png

  Open full size

  image.png

• Comments 0
• Votes 1