ClearCollect(
OpenColumnsCollection,
Filter(
[
If(First(col_OpenAudits).Column1.Value = "Open", "Column1"),
If(First(col_OpenAudits).Column2.Value = "Open", "Column2"),
If(First(col_OpenAudits).Column3.Value = "Open", "Column3"),
If(First(col_OpenAudits).Column4.Value = "Open", "Column4")
],
Not IsBlank(Value)))
ClearCollect(
OpenColumnsCollection,
Filter(
[
If(ThisItem.Column1.Value = "Open", "Column1"),
If(ThisItem.Column2.Value = "Open", "Column2"),
If(ThisItem.Column3.Value = "Open", "Column3"),
If(ThisItem.Column4.Value = "Open", "Column4")
],
Not IsBlank(Value)))
WarrenBelz
106
Most Valuable Professional
MS.Ragavendar
75
Michael E. Gernaey
52
Super User 2025 Season 1