Pivot App- Error! Column titles are not unique among input columns. (1133)
Can you help me? I run to this error when doing a Pivot. Thanks.
Best Answer
-
I've seen this error when the columns that Pivot is attempting to create in the target sheet are too similar due to similar input values from the source sheet.
One way to stop this from happening is to create your Pivot slowly:
1 . First, define less Rows and Values in the setup.
2 . Run the Pivot workflow.
2 . Edit the workflow to add additional rows and values.
This helps the Pivot map the correct columns into the sheet individually. Let me know if this works for you!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
I've seen this error when the columns that Pivot is attempting to create in the target sheet are too similar due to similar input values from the source sheet.
One way to stop this from happening is to create your Pivot slowly:
1 . First, define less Rows and Values in the setup.
2 . Run the Pivot workflow.
2 . Edit the workflow to add additional rows and values.
This helps the Pivot map the correct columns into the sheet individually. Let me know if this works for you!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives