As long as the user is logged into ETO already, and has security to see the participant information and the site they are enrolled in, the following formula will create a link to a participant's dashboard in ETO:
="" + FormatNumber([Participant Site Identifier];"0000")

  1. Cut/paste this formula into a cell or create a variable that can be used in other places in the report.
  2. Right-click onto the field after placing the formula into the report.
  3. Select Linking.
  4. Check Read Content as Hyperlink.

Did this answer your question?