MULTIPLE AND ON MULTIPLE COLUMNS wANCESTORS

ncanales

Hi there... really need help 😯

I have a list of actions, all actions are either a PARENT action (Outdented) or child actions (Indented). I added a column with =COUNT(ANCESTORS()) to have 1,0 depending on the case.

I have another column with a "Due date", and another with "Completion Due Date" where I want to monitor PARENT actions only. If the Due date has passed and the Completion Date is empty, it should read as Overdue.

The formula should do the following:

a) if its a child, then, "CAPA CHILD",

b) IF "Due Date" is today or later, then "On Time", regardless of what it says on "Completion Date"

c) IF NOT check if "Completion Date" is after "Due Date" then it's Overdue, otherwise "On Time"

So Im doing the following, getting an "Unparseable error"

=IF(ANCESTORS@row = 1, "CAPA CHILD", IF([CAPA Due Date]@row)>=TODAY(),"ON TIME","OVERDUE"))

N

Genevieve P.

Hi @ncanales

It looks like you just closed off that second IF statement too soon, adding in an additional ) which is read as a typo.

Try this:

=IF(ANCESTORS@row = 1, "CAPA CHILD", IF([CAPA Due Date]@row >=TODAY(),"ON TIME", "OVERDUE"))

ncanales

Thanks... I knew I was close 😱

Genevieve P.

Hi @ncanales

It looks like you just closed off that second IF statement too soon, adding in an additional ) which is read as a typo.

Try this:

=IF(ANCESTORS@row = 1, "CAPA CHILD", IF([CAPA Due Date]@row >=TODAY(),"ON TIME", "OVERDUE"))

ncanales

Thanks... I knew I was close 😱