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
146,513
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,666
Most Valuable Professional