Thursday, November 1, 2018

Add a Column in a Custom Project Saved Search which Calculates the Total Number of Days between Projected End Date and Actual End Date

1. Navigate to Lists > Search > Saved Searches > New > Project

2. Under Results > Columns
- Add a Formula (Numeric) field Formula {projectedenddate} - {enddate}
- Custom Label Number of Days between Projected End Date and Actual End Date
- Set
- Add
- Preview

Note
: In order for the formula to work, the fields Projected End Date and Actual End Date should have values, which were manually filled in. These fields can be exposed when the project form is customized.

No comments:

Post a Comment