Pivots nots working ?

01/17/22
Accepted

Hello team,


It's been a few hours I've been trying to create now Pivot table but none of my attempts today were successful.

All Pivot creations are still "in process"

Is someone else experiencing the same issue ?


Thanks

Pierre-Eric

Best Answers

  • ok it finally worked & I don't know what was blocking.

    But it works fine now.

    Thanks

  • Genevieve P.Genevieve P. admin
    Answer ✓

    Hi @Pierre-Eric Collette

    Thanks for following-up to let me know it worked!

    It does sound like the size of your source sheet may have been causing the Pivot to time-out, so creating a Report with the relevant data is what I would have suggested.

    If this happens again, please reach out to Smartsheet Support with a screen recording, the sheet name or URL, and details on when you were able to last run a Pivot successfully.

    Cheers,

    Genevieve

Answers

  • Hi @Pierre-Eric Collette

    The Status for the Pivot App is currently set to all systems operational (see: https://status.smartsheet.com/) and I personally just tested and created a Pivot without an issue.

    Is it possible this had to do with your network connection yesterday? Are you still experiencing the same issue today? If you are, would you be able to test this on a different browser or incognito mode to see if this helped? (See: Issue: Smartsheet Is Continuously Loading, Not Responding, or Not Displaying Certain Items)

    Cheers,

    Genevieve

  • Hi Genevieve,

    Thanks for the answer.

    I've tried the anonymous browser & also tried to run a pivot on a smaller sheet.

    But I still get the issue.

    Is it possible my personal queue is blocked by some pivot still running in the background in indefinite loop ?

    I'll keep trying different routes to try fix this issue.

    Please don't hesitate if you have any other ideas to explore.


    Thanks,

    Pierre-Eric

  • update: I managed to create a pivot on small sheet

    It seems the other pivot I'm trying to create has too much data (4500 lines & 95 columns) to compute.

    I've created a report (2 fields & 4055 lines) on the heavy sheet to limit the data that the pivot has to manage.

    But it doesn't seem to help.

    The odd thing is last week I created a pivot on a sheet as heavy and it worked.

    Would you have any recommendation to make this pivot work ?

    Thanks

    Pierre-Eric

  • ok it finally worked & I don't know what was blocking.

    But it works fine now.

    Thanks

  • Genevieve P.Genevieve P. admin
    Answer ✓

    Hi @Pierre-Eric Collette

    Thanks for following-up to let me know it worked!

    It does sound like the size of your source sheet may have been causing the Pivot to time-out, so creating a Report with the relevant data is what I would have suggested.

    If this happens again, please reach out to Smartsheet Support with a screen recording, the sheet name or URL, and details on when you were able to last run a Pivot successfully.

    Cheers,

    Genevieve

  • Thanks Emma for your reply.

    Good learning from this issue !


    Best,

    Pierre-Eric

Sign In or Register to comment.