| Note |
|---|
Once this page is ready, ask Mike to make it public. Looks like it is possible to not be indexed by search engines: |
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)
...
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)
...
- - 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)
...