SmartSheet Integration with OpenAir for Budget Management

edited 09/18/23 in Add Ons and Integrations


Could you please confirm if there is any recommended way for integrating SmartSheet with OpenAir? The details are as follows -

  • SmartSheet is used for Portfolio level reporting. It includes the list of projects, status, health indicator columns for tracking purposes
  • OpenAir is used by the project teams to book the hours. Billing happens on the basis of booked hours (T&M)
  • The requirement is to integrate OpenAir with SmartSheet so that for each project, SmartSheet portfolio summary can show things like Total Project Budget, Hours Used, Hours Pending, Budget Consumed, Budget Left etc.