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"))
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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"))
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks... I knew I was close 😱
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!