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 ?
ok it finally worked & I don't know what was blocking.
But it works fine now.
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.
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)
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.
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 Emma for your reply.
Good learning from this issue !
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 :(
Hi @Kayla Q
I hope you're well and safe!
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!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Hi, Can dynamic views be accessed on smartphones/mobile devices? I don't see this option on the app.
I am trying to create a library of all the smartsheets we have using Bridge and automatically update this list as more sheets are added. Basically it will list sheet name, id, owner and link I have difficulty to figure out how to add them one by one. it only adds one row on the sheet. I feel like there may be have to be…
I have finally gotten my first bridge to Smartsheet workflow working. My workflow copies project plan baseline dates to an original baseline field the first time a baseline is set, and then will not set it again. This works when I manually setup a trigger in bridge for a specific project plan sheet. However, I have 75…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.