Max Formula for Yes/No fields?
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
-
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 EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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."
-
Hi Andrée,
please find attached a screenshot of the table I was referring to.
Thanks,
Mathias
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 215 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives