Best Of

Thank you that worked!

Hi @Tony Fronza,

See if this works out better for you.

=IF(CONTAINS("In Progress", CHILDREN()), "In Progress", IF(COUNTIF(CHILDREN(), "Complete") + COUNTIF(CHILDREN(), "Canceled") = COUNT(CHILDREN()), "Complete", "Not Started"))

Notes:

• This can only be put into the parent row, cannot be a column formula
• If any of the [RFP Status]@row cells are blank, this will not work as the COUNT formula only includes cells with values

Hope this helps,

Dave

@DKazatsky2 never mind! There was an issue with the sheet's formatting. It's working now! Thanks again.

Hi @Brooks,

This is happening because the COLLECT statement is including the row with "Feedback" as a type, we need to ensure the COLLECT only has the "Focus Group Volunteer".

Try this one.

=IF(AND(Internal@row = "No", Type@row = "Focus Group Volunteer"), IFERROR(RANKEQ(Number@row, COLLECT(Number:Number, Type:Type, "Focus Group Volunteer", Internal:Internal, "No", [Patron Type]:[Patron Type], OR(@cell = "Faculty", @cell = "Instructor", @cell = "Visiting Scholor")), 1), ""))

Dave

@sweta22 Yes you can do that!

I went ahead and made a video to answer you question. Let me know if that works for you!

Hi @NCookBT83,

I think your syntax is off. It is correct in the formula you say is working, but when you added the second criteria, it looks like you reversed things in the COLLECT portion.

See if this works.

=IFERROR(JOIN(COLLECT({Sheet - QER Assembly}, {Sheet - QER Client ID FX}, [Client Number]@row, {Sheet - QER Workflow Des}, OR(@cell = "Year End Planning", @cell = "Year-End Planning")), ", "), " ")

*Untested

Hope this helps,

Dave