Formula to pull related date from another table

[Chris_Branaman]

I’ve read through a bunch of other posts but haven’t found anything that solves for my particular use case:

I created a base table containing all cards from a JIRA project (not sure if that’s relevant).

The base table contains Epics (Parent), and Stories/Bugs/Tasks (Child), and all related fields (status, start and due dates, linked issues, etc)

Epics also have an associated field called “Epic Theme” (child issues do not have the Theme field)

In a sub-table, I have all stories listed out, and what I want to do is basically

‘If a story (child) belongs to an Epic (parent), apply Parent “Theme” field to that story.’

Hopefully I explained that well enough.
Any ideas or suggestions would be SO greatly appreciated.

[Piet_Strydom]

Hi Chris,

Welcome to the community!

It would help tremendously if you could share a copy of your doc.

P

[Chris_Branaman]

I’m pulling data directly in from Jira so I don’t have a doc.

[Melanie_Teh]

@Chris_Branaman

welcome to the community

please see link below of demo doc done for you. its copy-able so you can dive under the hood for the formulas.

but in essence -

wasnt sure if you wanted the theme for all rows (including epics) i.e. “Parent Theme” column or just for the stories i.e. “Parent Theme 2” column.

also i didnt know what you meant by

In a sub-table, I have all stories listed out, and what I want to do is basically

like if this was a separate table or just a view, but judging from your similar post on reddit - i gathered its Epics, Stories/Bugs/Tasks are in one table.

Hope this helps!
Cheers!
Mel

[Chris_Branaman]

Let me try and clarify with the attached screenshot.
I have Epics (Parent) and Stories (Child)
For every Story, I want to find the Parent value for “Epic Theme”
Then apply that value to the Story “Theme Mapping” field.

Hopefully that is a bit more clear?

[Melanie_Teh]

@Melanie_Teh

parent theme 2 was the column you are after.

[Chris_Branaman]

I appreciate your assistance. When following this formula I’m getting an error

[Melanie_Teh]

ive amended that data in demo doc to match your screenshot data and column names.
build is the same / have not changed formulas etc.

Not sure if you referred to doc in first instance?
regardless, hopefully it might make more sense now

[Melanie_Teh]

@Chris_Branaman

i havent worked with jira pack/sync table but i assume if its a bit like google sheets sync table, its more like a “read source” so there are no relations made. so you would have to create a coda column to reference parent column and then can reference the “My exp theme”

[Chris_Branaman]

That’s it! That did the trick.
Thank you so much for the help!

[Chris_Branaman]

For those interested, I created a related text column for Issues, Parent, and Epic and once I did that my column formula worked like a charm.