nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

IF formula for Status of Child

heather48261

Hi - I'm looking for a formula that will display "All tasks complete" in the Parent Status cell, if the Status of all Child tasks is set to "Complete" (and will display "Incomplete Tasks" if any Child tasks have any other status).

Find more posts tagged with

Formulas

IT & Operations

Comments

Shaine Greenwood

Hi,

Try an IF statement with a COUNTIF function like the following:

=IF(AND(COUNTIF(CHILDREN(), "Complete") > 0, COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN())), "Complete", "Incomplete Tasks")

Sign in to join the conversation!

Quick Links

Trending discussions

Need to parse text and Remove Data
I am trying to find a way to look at text fields and automatically remove date and time stamps plus employee names. Any recommendations on identifying and removing text strings that meet the below formats: YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] We have a…
Predecessor question
I need the Date of Sample Shipment to start within 20 days of the Date of Manufacturing Start Date. However, the predecessor I have there isn't working properly. What should it be? Thank you so much
Column formula resulting in #circular reference
Does anyone know how to revert a sheet to a prior version after a column formula resulted in replacing all of the values with #circular reference? Would all entries have to be manually re-entered?