Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Just encountered the hard limit of 20,001 rows when exporting a report to Excel, Took me awhile to figure out what happened. Just wish there was a simple prompt to alert me to the issue. 20,001 is a bit low in my opinion.
Hi Mike,
This might help.
Please submit an Enhancement Request when you have a moment.
Only the first 20,000 rows will be included in the Excel document.If your report has more than 20,000 rows, create multiple reports that pull in fewer rows and export each report as a separate Excel file.NOTE: If a sort was applied to your report, fewer than 20,000 rows may be exported.
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hi everyone, I am trying to set up a standard "Move Row" automation to archive completed items, but my newly created destination sheet is completely invisible to the search bar in the automation builder. Because the "Select a destination sheet" window was recently updated and no longer has the manual Workspace/Folder…
Hi, We are on an Enterprise Smartsheet plan with SSO enabled in the US region. Have created a workspace, dashboards, contact list and etc. and shared it with an external contractor. External contractor already has an account in the Australia region. Tried to setup another account with the same email address (with Gmail) in…
Hello Team, I have created a dashboard based off of a summary sheet. The summary sheet pulls data from data sheets through links. My data sheets have formulas that project future dates for when events may occur but these dates are just projections. They are overwritten by acutal dates when events are completed. The issue…