Change Ownership of a Sheet, Report, or Sight

If you need to transfer ownership of sheets, reports, or Smartsheet Sights between people, you can do so for a single Smartsheet item or as a bulk transfer (only available to System Admins on Team, Business, and Enterprise accounts). Sheets and reports can only be transferred to a licensed Smartsheet user.

NOTE: This article discusses transferring ownership of sheets, reports, and Sights that have been individually shared—even if they're contained in a workspace. If you're looking to transfer ownership of an entire workspace, see Change the Workspace Owner or Remove Collaborators.

Requirements Before You Can Make the Transfer

Make sure that the following requirements are met before attempting to transfer items:

  • If you need to transfer items that are in a workspace, the items must first be shared individually. More information on how you can share Smartsheet items individually is available in the Sharing Sheets, Reports, and Smartsheet Sights help article.
     
  • The person you're transferring sheets, reports, or Sights to must have a paid license.

    NOTE: If you're on a Individual subscription plan and also need to transfer your user license to another account, you can use our instructions to Transfer your Paid Subscription.
     
  • If you're transferring reports, the person you're transferring them to must have a Team, Business, or Enterprise plan.
  • If you're transferring Sights, the person you're transferring them to must have a Business or Enterprise plan.

Transfer Ownership of a Single Smartsheet Item

    Give Ownership of a Sheet, Report, or Sight to Someone Else

    1. Share the sheet, with any sharing permissions, to the intended new sheet owner. If the sheet is located in a workspace, the intended new owner will need to be offered Admin access. (See Sharing Sheets for more information on how to share sheets.)
    2. After the sheet has been shared, open the Sharing form by clicking the Sharing tab at the bottom of the sheet and expand the Collaborators section. (Click the arrow next to Collaborators.)
    3. In the Dropdown next to the intended new sheet owner, select Make Owner.


    NOTE: If your trial has expired, or if you’ve canceled your paid subscription, no approval email is sent and the transfer of ownership happens automatically.

    What happens next?

    Once the existing owner clicks on the Approve link in the email, the requestor will be made the new sheet owner and the previous owner will become an Admin on the sheet. All other shared collaborators (if any) will remain shared and will retain their sharing permission level. A confirmation email is sent to the requestor stating that the request was approved or declined. The sheet now counts against the sheet limit in the new owner’s account.

    Request to Take Ownership of a Smartsheet Item

    Only licensed users (and not users on a free trial) can take over ownership of a sheet. 

    NOTE: You can use these same instructions to transfer ownership of a report.

    1. Share the sheet, offering Editor or Admin access, to the intended new sheet owner. If the sheet is located in a workspace, the intended new owner will need to be offered Admin access. (See Sharing Sheets for more information on how to share sheets.)
    2. After the sheet has been shared, have the intended new sheet owner log in and click their Home tab at the top of Smartsheet.
    3. The intended new sheet owner should look in the left sidebar and click on the name of the folder or workspace where the sheet is located. The sheets it contains will be displayed in the middle of the screen.
    4. The intended new sheet owner can right-click on the name of a sheet and select Make me the Owner.

      Home tab: Make Me the Owner
       
    5. An email is sent to the existing owner with a link to approve the change of ownership request.

      NOTE: If the existing sheet owner’s trial has expired, or if the existing sheet owner has canceled their paid subscription, no approval email is sent and the transfer of ownership happens automatically.

    What happens next?

    Once the existing owner clicks on the Approve link in the email, the requestor will be made the new sheet owner and the previous owner will become an Admin on the sheet. All other shared collaborators (if any) will remain shared and will retain their sharing permission level. A confirmation email is sent to the requestor stating that the request was approved or declined. The sheet now counts against the sheet limit in the new owner’s account.

    Back to top


    Bulk Transfer Items (Team, Business, and Enterprise Only)

    System Admins of Team, Business, and Enterprise accounts can bulk transfer sheets, reports, and Sights between licensed users.

    NOTE: This process will transfer all sheets, reports, and Sights that the licensed user owns. If you need to selectively transfer certain items, use the steps above to transfer on a sheet-by-sheet basis.

    1. Click Account in the upper-right corner of the screen and select Account Admin to display the Account Administration form.
    2. Click the User Management tab.
    3. Click the drop-down arrow next to the user whose sheets you want to transfer and select Transfer Owned Sheets to Other User.

      This will display the Account Administration form.

      User Management: Transfer Owned Sheets

      TIP: Before transferring, you can see which sheets a user can access by selecting Download User Sheet Access Report.
       
    4. Select the person that you want to transfer items to and then click OK.

    Transferred sheets, reports, and Sights will appear in the Sheets section of the new owner Home tab in a folder named Transferred from [email address of previous owner].

    After transferring, the original owner assumes Admin sharing permissions on the items, while the new owner assumes Owner permissions. All other shared collaborators (if any) will remain shared and retain their sharing permission level.

    Back to top

    Was this article helpful?
    YesNo