Formatting a combined dates table

[Carolie_Delisle]

Hi all!

I’ve used this set-up to create a new combined dates table, I’ve changed it to retrieve dates from 3 different columns and created a row for each. This way I can have a calendar that shows 3 single dates for the same project.

But now ! I would like to have it inherit the conditional formats (color) from the original table.

So far I’ve tried adding the _color() formula to the Column Value, but the “Red” or “Hex” aren’t doing anything.

I can’t inherit the conditional formatting either, since it’s a table to table not a calendar type ish thing.

Where I am at; trying to modify my formula to return the Column Header and then do a conditional formatting on my new table based on the new Column Header category. But I can’t seem to find a way to retrieve a Column Header within Coda (only during imports).

Any ideas or suggestions?

Current State of my formula:

Results for a specific Project, I have my 3 dates which is the desired result. But I’d either want them to be the same format as source or (failing that) return the column header associated with date, to add conditional formatting it in this table.

THANKS !

[Pablo_DV]

I’m not sure I understand what you’re issue is, but in the original post you mention, the author simply hardcodes a value for the Source column and applies conditional format according to that value. For example if the row came from the ‘Project’ table then Source would be also ‘Project’ and likewise for procurement.

There’s no formula to retrieve the column name in coda, but you could just create an additional column and hardcode that value in your formula, similarly to the post you lnked.

[Carolie_Delisle]

I was able to manage some of it, but the difference with this second table is that it’s coming from a single table but merging 3 columns into individual and distinct rows in order to be able to generate a single date calendar.

Each date is a specific type of event link to a single project. I want to retrieve the event type (which is the column name).

[Carolie_Delisle]

Resolved !

Here’s my solution, I did hardcode it by adding a column. Then applied conditional formatting.