I believe grouped columns are subject to filters.
You can drag each conditional formatting rule up or down to establish its priority relative to the other conditional formatting rules.
That was the only way I could get it to work.
Whenever it’s an option, I always prefer a direct Lookup to Select list. In this case, it makes it easy to auto-populate columns in the button-added row. Look at the formula in
event_status2 to see how.
I haven’t seen anything about locking tables.
It makes it easier to build that big old honking concat formula in
Yes, you can. (Not everything can be pasted though, like
@refs. Those must be typed into the formula editor.)
I’d like an official answer to this question also.