Add Ons and Integrations

Add Ons and Integrations

Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

Why is Pivot not adding new columns?

I have several pivot tables that are linked to a sales database. The pivot columns based on the month. The issue I'm having is as the database grows and sales for the next month are added to the database the pivot table is not adding the new month column. How do I fix this?

Best Answer

  • ✭✭✭✭✭✭
    Answer ✓

    Hi @TJones Hoshizaki ,

    Check the update settings in your pivot table. Make sure it's not sett to never; which then requires a manual update. Try doing a manual update and see if that refreshes the data for you.

    Good luck.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

  • ✭✭✭✭✭✭
    Answer ✓

    Hi @TJones Hoshizaki ,

    Check the update settings in your pivot table. Make sure it's not sett to never; which then requires a manual update. Try doing a manual update and see if that refreshes the data for you.

    Good luck.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Trending Posts