A way to Formulate status of parent row

Mohammad Sleem

Hello people,

I´ve been wondering if it is possible or there´s a way around it to formulate a cell of a parnet row depending on the children?

For example:

Go to Class In progress

get in the car Done

Drive to school In Progress

Park and go to class Pending

so the thing is, can i formulate the Go to Class status? for example if all children are done then "Done" if not then "In progress" or "Pending".

John_Foster

Hi @Mohammad Sleem,

This is indeed possible. We manage this internally, by setting the sheet up as a project sheet, we then set a column formula to change the status based on the Completion %. This way the parent rows will automatically update as required.

To do this change the view to Gantt View, then click on the settings icon in the right-hand corner of the sheet, but to do this the sheet will need two date fields and a field that can be used to hold a Completion %.

Hope this helps!

John

Mohammad Sleem

@John_Foster so basically what you´re saying is that for example, if 100% complete then Done, ifless then in Progress.

This logic. hmm

Thank you!

John_Foster

Hi @Mohammad Sleem,

Yes, exactly that, the formula I use is below.

=IF([% Complete]@row = 1, "Completed", IF([% Complete]@row = 0, "Not Started", "In Progress"))

The bit that confused me when I started using this is that 100% = 1 and 50% = 0.5, so the formula uses 0 as not started and 1 as complete, other wise it is in progress.

John