Pivots nots working ?

Pierre-Eric Collette

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

Pierre-Eric Collette

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

But it works fine now.

Thanks

Genevieve P.

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

Genevieve P.

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

Pierre-Eric Collette

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

Pierre-Eric Collette

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

Pierre-Eric Collette

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

But it works fine now.

Thanks

Genevieve P.

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

Pierre-Eric Collette

Thanks Emma for your reply.

Good learning from this issue !

Best,

Pierre-Eric

Kayla Q

I'm having the same issue. I've created several other pivots from the same master sheet successfully, but this one is getting stuck in the creation process.

Not sure what the issue is :(

Andrée Starå

Hi @Kayla Q

I hope you're well and safe!

Strange!

If you haven’t already, I recommend reaching out to the Smartsheet Support Team.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!