Max Formula for Yes/No fields?

madamaschke

Dear all,

I have a rather complex sheet that contains some hundred rows. Each row represents a certain entity that is described by some text columns (5). The next 10 columns are yes/no columns, where any combination is possible due to decisions made by that entity. At the end some columns with dates following.

I am now faced with the following issue and hope you guys are smarter than me

For some of those entities a second or third row is need to capture decisions made at a different date than before. For reporting reasons those kind of details from before need to be preserved. I have already created children rows for the new entries but falling short at the way to find a way that for the yes/no columns the parent row should reflect the max value of the children rows.

Is there any way to get this working without creating another 20 columns?

Thanks,

Mathias

Andrée Starå

Hi Mathias,

If you can share the sheet or some screenshots that would be very helpful and make it easier to help.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

Paul Newcome

It almost sounds like a CHILDREN function should work for you.

 

The specifics would depend on what exactly you mean by "the yes/no columns the parent row should reflect the max value of the children rows."

 

 

madamaschke

Hi Andrée,

please find attached a screenshot of the table I was referring to.

 

Thanks,

Mathias