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.
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.
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.
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.
