MULTIPLE AND ON MULTIPLE COLUMNS wANCESTORS
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
Best Answers
-
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"))
-
Thanks... I knew I was close 😱
Answers
-
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"))
-
Thanks... I knew I was close 😱
Help Article Resources
Categories
Check out the Formula Handbook template!