#NO MATCH on INDEX COLLECT function
Hello! I am working on a formula to pull an ID for the row that has the LatestDate, and a checkbox is ticked. As there may be more than one matching row with these parameters, FROM those I need to return the ID for the row with the most recent CreatedDate. This will yield a maximum of one result. This is the formula that…