I am trying to automatically populate the Parent "Content Development Status" column based on the most recent "Child" in the "Tasks" column, but there are certain Children rows in the Task column that I want to ignore. For example, if there is a webinar delivered, I do not want this to populate in the Content Development Status Parent Column, instead I want the most recent Child that is not webinar delivered to be populated.
I created a helper checkbox column that checks a box for all Children rows in the "Task" column that do not equal "Webinar delivered." I have a rather long if/then formula for all of the potential drop down options in the Task column, and it works for those pieces of content that do not have webinar delivery, but when I try it on content that needs the webinar delivered filtered out, it returns "Invalid Value."
Here is one part of the nested If formula that I am currently using:
=IF(INDEX(COLLECT(CHILDREN(Tasks@row), CHILDREN([Not Webinar/Workshop]@row), @cell = 1, CHILDREN(Start@row), MAX(CHILDREN(Start@row))), 1) = "Approved by Compliance", "Approved by Compliance")
Appreciate any insight that you have!