👋 Welcome! Introduce yourself and connect with your peers in Education to receive your industry badge.

Who is using Smartsheet and Teams integrations?

Johne Johnson
Johne Johnson ✭✭✭
edited 05/16/24 in Education

Hi,

I am with a large school district and working on the integration with Teams and Smartsheet. Looking to see who else is doing the same out there.

Johné Johnson

Johne.Johnson@sbcusd.k12.ca.us

San Bernardino City Unified School District

SBCUSD | Ast. Director - CCBO | Information Technology

793 North E Street San Bernardino CA 92410 | t:951.377.5341 | 46277

Best Answer

Answers

  • Stacey Carrasco
    Stacey Carrasco ✭✭✭✭✭✭
    Answer ✓

    @Johne Johnson

    We are not but I'm curious to learn more about it. Our district uses Teams and if there was an intergration with smartsheet I'd be happy to learn more about that.

    Senior Program Coordinator

    De Anza College

  • CWimer
    CWimer ✭✭

    Hi @Johne Johnson,

    I'm writing to share a quick guide on enabling the Smartsheet integration with Microsoft Teams. This integration allows you to easily access and collaborate on Smartsheet sheets, dashboards, and reports directly within Teams channels. Here's a step-by-step breakdown:

    Enabling the Integration:

    1. Select your desired channel: In the Microsoft Teams left panel, choose the channel where you want to integrate Smartsheet.
    2. Click the "Plus" icon: Locate the "+" icon beneath the channel name and click to display available integrations.
    3. Choose Smartsheet for Teams: Select "Smartsheet for Teams" from the list of options.
    4. Review and Accept Agreements: Click "Accept" to agree to the Smartsheet license agreement.

    Granting Permissions:

    1. Connect to Smartsheet: Click "Connect to Smartsheet" to initiate the connection.
    2. Authorize Access: Click "Allow" to grant Smartsheet access to integrate with Microsoft Teams.

    Using the Integration:

    Once the integration is enabled, you can add Smartsheet sheets, dashboards, and reports as "Tabs" within your chosen Team channel. This allows for easy collaboration on these documents within the familiar Teams environment, especially for those less comfortable with dedicated Smartsheet software.

    Note: Depending on your organization's IT security settings, you might need assistance from your IT team to complete the permission steps.

    Feel free to reach out if you have any questions!

    Best regards,

    Christina

    Happy Learning!

    Christina Wimer, C/L/RVT, LATG, VDT, CPRI, FFP, QPRI, GPM, CCFP

    Program Manager, Talent and Learning

  • I have done the integration but can only see one folder and in it, only a few files. What am I doing wrong?

    Johné Johnson

    Johne.Johnson@sbcusd.k12.ca.us

    San Bernardino City Unified School District

    SBCUSD | Ast. Director - CCBO | Information Technology

    793 North E Street San Bernardino CA 92410 | t:951.377.5341 | 46277

  • swfascetti
    swfascetti ✭✭✭✭✭

    This is great — I have a dynamic view in my dashboard and get a note that dynamic view isn't supported in third party sites. Any work around? Thanks, Sara

  • We now can see all the folders under sheets!

    Johné Johnson

    Johne.Johnson@sbcusd.k12.ca.us

    San Bernardino City Unified School District

    SBCUSD | Ast. Director - CCBO | Information Technology

    793 North E Street San Bernardino CA 92410 | t:951.377.5341 | 46277

  • Johné Johnson

    Johne.Johnson@sbcusd.k12.ca.us

    San Bernardino City Unified School District

    SBCUSD | Ast. Director - CCBO | Information Technology

    793 North E Street San Bernardino CA 92410 | t:951.377.5341 | 46277

  • Deena Duran
    Deena Duran Overachievers

    Hello @swfascetti , I have not tried the official integration of Smartsheet into teams. However, I have embedded dashboards onto Teams go to Add a Channel, and selecting "webpage." Perhaps you can try doing that and using the Dynamic View URL. If that doesn't work, perhaps imbedding the Dynamic View onto a dashboard, and putting the dashboard on Teams (as described above)? Let me know if that helps!

    Deena Duran, MA (She/Her)

    🌟 Smartsheet Overachiever, Mobilizer, and Early Adopter 🌟

    🎓️ Core App, Project Management, and System Administrator Certified 🏅

    Senior Business Analyst

    University of New Mexico Health Sciences

  • Isis Taylor
    Isis Taylor ✭✭✭✭✭✭

    @CWimer

    Thanks for sharing. We are thinking of using the integration at my organization and this is very helpful.

    Isis Taylor

    🎓️ Core App and Project Management Certified 🏅

    🌟Peer Connect, Mobilizer, and Early Adopter Program

    Business Analyst Senior

  • We also use ours to build Master Dashboards, links to all our projects and for Onboarding new hires.

    Johné Johnson

    Johne.Johnson@sbcusd.k12.ca.us

    San Bernardino City Unified School District

    SBCUSD | Ast. Director - CCBO | Information Technology

    793 North E Street San Bernardino CA 92410 | t:951.377.5341 | 46277