Answer
- Approver Due Date Variance
- When a Submittal is Closed, this column is equal to Approver Return Date - Approver Due Date
- When a Submittal is Open, this column is equal to Current Date - Approver Due Date
- Approver Returned Date Duration
- When as Submittal is Closed, this column is equal to Approver Returned Date - Approver Sent Date
- When a Submittal is Open, this column is equal to Current Date - Approver Sent Date
- Action required by Duration
- When a Submittal is Open, this column is equal to Current Date - Action required by Sent Date