Summarize Tool for Open Items

Question

Gurus!

Who said work doesn't happen on Sundays!

I am stuck. I need to summarize data to match the below snip. Essentially, I have data with issues, if any program has an open issue while others are closed that program remains 'Open'. If all issues are closed then that program is 'Closed'.

Any ideas?

flying008 · Answer

Hi, @ZoeM

Please see the formula:

IIF(Contains([Program Status], 'OPen'), 'Open', 'Closed')

alexnajm · Answer

Try this then!

Summarize Tool for Open Items.yxmd

ZoeM · Answer

Thanks for keeping me honest alexnajm!

The Program Status field is actually blank! The statement I am looking to evaluate is "If one issue is Open then the program level is Open even if other issues are closed". Only when all issues are closed should it evaluate the program as closed.