Max Formula for Yes/No fields?

07/31/18 Edited 12/09/19

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

Comments

  • Andrée Starå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

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Paul NewcomePaul 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."

     

     

  • edited 08/13/18

    Hi Andrée,

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

     

    Thanks,

    Mathias

    Example.JPG

Sign In or Register to comment.