Add .value in formula

[Victor]

Hello community!

I am currently working on a document using the Jira pack, and trying to build an SLA tracker.

I have these simple tables

This is the formula i am trying to use -

if(
Not(thisRow.Status.In(“Done”, “Won’t Fix”, “Won’t Do”, “Duplicate”)),
If(
Today() - thisRow.Created > thisRow.[Resolution SLA (days)],
[Out of SLA].Value
OK.Value ),
OK.Value
)

I added the Column relation to the SLA table, but for some reason, I can’t pull the ‘Ok’ and ‘Out of SLA’ values.

Am I missing something?

[Victor]

Adding the second table since i couldn’t post it in the original topic.

[joost_mineur]

Hello @Victor ,

Please share a (dummy) doc so we don’t have to replicate your doc ourselves in order to help you.
I think nesting “If” formulas is not the way to go.
I also think your formulas fail because you are comparing apples and pears: “OK” is a text value in your formula, but it looks like you are trying to compare with a Coda “object” (I call the pill type things objects).

So either add .ToText() when you are trying to compare a pill with a text object, of, better, type @Ok to enter the OK pill in your formula.

Greetings,
Joost