The client is a government contractor who supplies technological resources and solutions to US government
The client wanted a tracker to manage the project billing and resources and overall progress of multiple projects
Required formulas and customization are to be implemented to achieve the form
Various details like contract type, status, contact details , funding expenditure can be captured, edited and
Form functionality is designed to evaluate the details entered and update the required field status
Solution
SharePoint site is built using Power Apps
Required customization and formulas are applied to successfully implement the form
User can create, edit and view the records using different
User can delete , save and add comments wherever
Various field data is evaluated and formulas are applied to calculate funding expenditure , (if more than or less than 70%) , based on the user submitting the expenditure details .
Impact
Increased project visibility to management
Automated Notifications for better tracking on escalations