Home |
Search |
Today's Posts |
#21
![]() |
|||
|
|||
![]()
On Wednesday, May 15, 2019 at 1:24:31 PM UTC-4, wrote:
go to values add value calculated field (at the bottom of the field list) set 'Summarize by' to 'Custom', and use the formula: =TO_TEXT('field_title') This is VERY helpful. Thank you for this creative solution. Hopefully, in the future Google makes this a directly supported feature. I will note if your original column header has a line break (carriage return) in it as such: Sales Person then you will get the dreaded #ERROR! "Formula parse error". There is a workaround I have found. Temporarily, change the column header you want to reference in the Calculated Field into a single word. In the case above, let's say we changed it to 'Person' (removing the word Sales and the following carriage return from the example above). Now go create the Calculated Field. In this case, the formula would be =TO_TEXT('Person') The field will be created in the Pivot Table without error. Now for the interesting part, you can go change the column name back to the original, and Google Sheets is then smart enough to handle the change. Thanks so much to for the original idea to use the T0_TEXT function. This is a really creative solution. |
#22
![]() |
|||
|
|||
![]()
On Wednesday, 15 May 2019 18:24:31 UTC+1, wrote:
go to values add value calculated field (at the bottom of the field list) set 'Summarize by' to 'Custom', and use the formula: =TO_TEXT('field_title') Brilliant! Thank you! |
#23
![]() |
|||
|
|||
![]()
On Wednesday, May 15, 2019 at 10:54:31 PM UTC+5:30, wrote:
go to values add value calculated field (at the bottom of the field list) set 'Summarize by' to 'Custom', and use the formula: =TO_TEXT('field_title') Great... your solution saved a lot of time for me. |
#24
![]() |
|||
|
|||
![]()
On Monday, August 3, 2020 at 4:34:49 AM UTC+2, wrote:
On Wednesday, May 15, 2019 at 10:54:31 PM UTC+5:30, wrote: go to values add value calculated field (at the bottom of the field list) set 'Summarize by' to 'Custom', and use the formula: =TO_TEXT('field_title') Great... your solution saved a lot of time for me. Hey all, adding on top of what's already shared here, I figured out how to combine all values. 🎉 =TO_TEXT(CONCATENATE(Feedback)) I also needed to add new lines to all entries so that they make more sense. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Tables-Text Values? | Excel Discussion (Misc queries) | |||
Calculating from values in pivot tables | Excel Worksheet Functions | |||
Pivot Tables - Ranking Values | Excel Discussion (Misc queries) | |||
Pivot tables with zero/null values | Excel Discussion (Misc queries) | |||
Supress Zero Values on Pivot Tables | Excel Discussion (Misc queries) |