Welcome!

Mark Parent Complete

MrMike

Hello,

looking for a formula that would mark the parent cell Complete after all the children cells are marked Pass.

Find more posts tagged with

Comments

Paul Newcome

Try something like this...

=IF(COUNTIFS(CHILDREN(), "Pass") = COUNTIFS(CHILDREN(), OR(NOT(ISBLANK(cell)), ISBLANK(@cell))), "Complete")

MrMike

Thanks for the reply but it shows unparseable.

Paul Newcome

Can you post your exact formula that you are using? Screenshots would also be very helpful. Sensitive/confidential data can be removed, hidden, or replaced with "dummy data" if needed.

Sign in to join the conversation!

Quick Links

Trending discussions

Referencing to Smartsheet table (consisting of 30+ columns) in INDEX/MATCH formula but shows error
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
Upgrade user mismatch
I have inly one user in my trial account. When I am trying to upgrade to PRO plan it is defaulting for 2 users and not allowing me to upgrade the plan for only one user. Please help.
Delete
How can I delete old sheets I no longer use from my account?