It might seem counterintuitive but I’m looking for a simple way apply “text formatting” (manual, not conditional) to every new row in a column. I detail below why this is in case anyone knows a solution to that issue.
Currently if I select an entire column and apply text formatting, that will not apply to new rows. Example:
I know formatting text with formulas is possible but I’d like to avoid that as it doesn’t seem to fit my use case (I detailed that at the end).
Last resort would be to use automations. But that seems a bit heavy-handed.
Reason:
This is a weird niche issue I encountered when using “expand” view on a row in a table. For relations to other tables we are offered to either use “table” layout to show the related row, or “field” view where it just displays the link to that row. These look as such (top is table, bottom is field):
The difference between the two in the image is also the formatting which is my issue.
On the 1st table / 1st column, I applied formatting through conditional logic. That name should be red and bolded, it looks like that in its own table, but here it’s displayed as plain white.
On the 2nd table / 1st column, I applied the formatting to the cell through right click > text formatting. This displays correctly.
So if the formatting on the 1st column will only work if I do it manually. This is a problem also because manual text formatting has fewer color options compared to conditional formatting.
The weird thing is that colors will work with conditional formatting if I change to the field view. The same name that was white in table view, will look like this in field view:
With all this I assume this is intended so I’m looking for a workound which would be some kind of auto-applying text fromat to new rows.
Bonus issue: Conditional formatting doesn’t work for any field in the expanded view except for some reason it will work on “relation” type columns:
(on the image the 1st column is formatted conditionally in the table to blue, but remains white, the 2nd column is a relation to another table where the display column is formatted conditionally to green, but because this is a relation column it will display the card with the correct formatting)
I want to avoid: using formulas to apply text formatting. The reason is my display column is usually the 1st one for visual clarity. Having duplicate column just for formatting would add a lot of clutter as I’d need the original to edit so it would mean having duplicate columns to get the color working. I also couldn’t hide the formula-formatted column because it’d be needed to display the colors automatically.
