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