Skip to main content

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!

 

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. 

Terms & ConditionsAccessibility statement