Daily Formula
Deduplicating:
thisTable.Filter(CurrentValue.Heading = thisRow.Heading).Count() > 1
Ready to Publish:
thisRow.Heading.IsBlank() OR
thisRow.Region.IsBlank() OR
thisRow.[Priority Level].IsBlank() OR
thisRow.Type.IsBlank() OR
thisRow.Category.IsBlank() OR
thisRow.Author.IsBlank() OR
thisRow.[Published Date].IsBlank() OR
thisRow.Platform.IsBlank() OR
thisRow.[Popularity Points].IsBlank() OR
thisRow.Content.IsBlank() OR
thisRow.Attachments.IsBlank() OR
thisRow.Source.IsBlank()