Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Re: Pivot Table with Text Values

90 0
cancel
Showing results for 
Search instead for 
Did you mean: 
JBJ
7 - App Architect
7 - App Architect

Hi everyone,

We're building a decision-making tool. This tool has tables for Topics, Participants, and Positions – each participant takes a position ('Go', 'No-go', or 'I don't know') on a topic. Each position type is matched with a numerical value: 1 for 'Go', -1 for 'No-go', 0 for 'I don't know'.

In the pivot table below, we'd like to display the participant's position in each cell instead of his/her position's numerical value. Do you guys have an idea of how to get this done?

Thanks!

CleanShot 2025-01-09 at 12.01.42.png

 

1 Reply 1
DisraeliGears01
7 - App Architect
7 - App Architect

This seems like the classic example of a SWITCH formula field (AT documentation here), which you could format as single select field and color. Without seeing the underlying base config I'm not precisely sure what table you need to put the formula in, but I feel like that's your solution.