- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 09, 2025 03:17 AM - edited ‎Jan 09, 2025 03:19 AM
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!
 
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 09, 2025 08:43 AM
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.
