You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 157 Next »

Once this page is ready, ask Mike to make it public. Looks like it is possible to not be indexed by search engines:

https://community.atlassian.com/t5/Jira-questions/Where-to-put-the-robots-txt-file-on-standalone-confluence-or/qaq-p/141572

Getting Started
Applications
Endorsements
Reviews
Testing Your Surveys
Best Practices



Harvard Catalyst Informatics is retiring Apply Hub. Qualtrics will be used instead to apply for courses, training fellowships, and grants. Genoa Polumbo and Bill Murphy can answer questions you may have about this transition. Please see the subpages (buttons above or links on the left) for more information.


Tracking Endorsements when using Post-Application Endorsement Survey

When the Endorse phase is complete (or during the endorsement cycle, but will need to be done again when all endorsements are in)

  • Download as CSV the data for both the application survey and the endorsement survey
  • Open them in two side by side windows
  • Click and hold the tab for endorsement sheet (bottom left) and drag it over to the right of the tab for the application sheet
  • You can close the window with the Endorsement sheet
  • Double click to rename the tab that you just dragged over to “endorsements”
  • Make note of the letter of the appID column (e.g. “S”)
  • Click on the tab for the application sheet

  • Locate the “appID” column and the “Is Endorsed?” column
    If you do not have an "Is Endorsed?" column, add one next to the "appID" column

  • Paste the following code into the first empty cell of the “Is Endorsed?” column (where there is a value for appID in the adjacent column)

    =IF(ISNA(VLOOKUP(AT4,endorsements!$S:$S,1,FALSE)), "?", "Yes")

    • - replace “AT4” with the cell number of the first record in the appID column  (the row number should match)
    • - replace “$S:$S” with the column letter you noted from the endorsements sheet (i.e. $AU:$AU)
    • The question mark “?” is to indicate that there was no endorsement found (as opposed to an explicit no)
  • Select/highlight the cell with the formula and as many cells below as needed (i.e. as long as there is a value in adjacent appID column)
  • Select Edit > Fill > Down
  • All cells should now be filled with either a Yes or a question mark





  • No labels