
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 18, 2020 04:54 AM
When a table is synced the field type of a formula is changed to long text (which makes sense).
Is there also a way to change it to short text? Long Texts can’t be used in Pivot tables (but results of formulas can). Therefore I’m not able to create the same pivot table in the original and the synced table.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 18, 2020 10:20 AM
Its not ideal but you could get around this inconvenience by adding a new formula field to your synced table that just copies the value of the synced field, and use that for the Pivot Table.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 18, 2020 10:20 AM
Its not ideal but you could get around this inconvenience by adding a new formula field to your synced table that just copies the value of the synced field, and use that for the Pivot Table.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 18, 2020 11:14 AM
Thats a good idea, that will work :slightly_smiling_face:
Of cause it’s not ideal, since there will be two visually identical fields in the table.
My quick fix that I did was to redo the formula, since I had all the required data in the synced table. But your solution is easier and more universal.
