SRSTAT returns Sampling Requirement statistics (count of results, percent complete...) for a sampling Requirement ID/Name.   

SYNTAX:

SRSTAT(ID/Name, Stat, ForDate) 

ID/Name: The ID (SAMPLEREQ.ID field) or the Sampling Requirement name in quotes.  Can be a number (i.e. 12), a cell reference (i.e. C2) to a cell that contains a number or string or  a quoted string that is a Sample Requirement Name.

Stat:  The field to get:

1. Count
2. %Complete
3. DaysInGroup
4. DaysIn
5. DaysRemaining
6. StatusCalc
7. NumReq

 

ForDate:  The function by default looks up the Sampling Requirement for the Start Date of the report.  A date string (i.e. "07/16/2014") or reference to a cell with a date in it, the sampling requirement will be used for this date.