Create and update entries in Smartsheet from Test Reporting & Analytics

Test Reporting & Analytics allows you to easily create, track, and monitor entries on Smartsheet without navigating away from Test Reporting & Analytics.

Prerequisite

Ensure that you have a Smartsheet account.

Integrate Smartsheet with Test Reporting & Analytics

To integrate Smartsheet with Test Reporting & Analytics:

1. Sign in to BrowserStack Test Reporting & Analytics.
2. Hover over the profile icon in the top navigation bar of Test Reporting & Analytics and select Integrations.
   
3. On the Integrations page, click Connect next to the Smartsheet logo.
4. On the Integrate with your Smartsheet account prompt, click Connect with OAuth.
5. Enter your login credentials and grant permissions, if prompted. You can view a success message to confirm Smartsheet integration.

Log an entry on Smartsheet

Ensure you have integrated Smartsheet with Test Reporting & Analytics.

1. You can initiate an entry on Smartsheet in two ways:
   • From the Tests tab of the Build Insights Dashboard, hover the cursor over the timeline graph of a failed test and click Report.
   • From the Timeline Debugging view, click the icon.
2. Click Smartsheet.
3. Select an organization and project from the menu. Test Reporting & Analytics automatically picks up all the fields in your Smartsheet project.
   
4. Click the Create tab and select the type.
   
5. Enter the details about the entry. Click Show all fields to view all the fields. Note that the fields in your Smartsheet project are auto-populated here by Test Reporting & Analytics.
   
6. Click Create.
   

You will receive a success message that the Smartsheet entry was created.

You can click View on the success message to view the entry on Smartsheet.

The Smartsheet entry gets associated with the test run. You can track the status of the entry from the test listing.

Metadata to add to Smartsheet

When you create a Smartsheet entry, Test Reporting & Analytics logs the following Metadata and other information to the entry and makes debugging easier:

• Session URL to view the issue on BrowserStack
• Build Name
• Build ID
• CI Environment
• CI Build URL
• Test Name
• Test URL
• Test Status
• Operating System
• Browser name and version
• Host Name
• Defect Type
• Duration
• isAutoAnalyzed flag
• Status of Build Runs
• Error message or exception
• Environment

As Test Reporting & Analytics automatically logs this information onto the Smartsheet entry, you can reduce manual work, debug faster, and improve data quality.

Update an entry on Smartsheet

Ensure you have integrated Smartsheet with Test Reporting & Analytics.

1. You can open the window to update a Smartsheet entry in two ways:
   • From the Tests tab of Build Insights, hover the cursor over the timeline graph of a failed test and click Report.
   • From the Timeline Debugging view, click the icon.
2. Select a project and organization from the Project drop-down.
   
3. Click the Update existing entry tab and select the entry you want to update.
   
4. Click Show all fields to view additional fields. Update the details.
   
5. Click Update.
   

You can confirm that the entry was updated after receiving a success message.