It it possible to change how to display row names in a dropdown list in a lookup column?
I have a table “Ideas” with two columns: “Idea Name” and “Attached to”.
Idea (a row in the “Ideas” table) can be attached to a row from 3 different tables (Initiatives, Projects, Tasks).
“Attached to” column is a lookup column that shows all rows from these 3 different tables with this formula:
ListCombine(Initiatives, Projects, Tasks)
It works fine, but I’d like to change how row names are displayed in a dropdown. Right now it’s just the names of Initiatives, Projects, Tasks all combined into one list. For example:
Design To Do System in Coda Create Kanban View for Tasks Style columns in Kanban View for Tasks
I’d like to change it to add pretext to the row names so it’s easier to see what is an Initiative in this list and what is a Task. Example:
Initiative: Design To Do System in Coda Project: Create Kanban View for Tasks Task: Style columns in Kanban View for Tasks
Is it possible?