Scenario: How can I display a select list vertically instead of clumped on a line?
Progress:
Project=thisRow.Project AND Task!=thisRow.Task AND thisRow.[Row ID].Contains(CurrentValue.[Parent Tasks]).Not()
Stretch progress bars to full column width: (otherwise use fixed multiplier: )
SwitchIf(
thisRow.[Item Category]="Package"AND thisRow.Rate!="",
Find(thisRow,thisTable.Filter([Item Category]="Package"AND Rate!="")),
thisTable.[Item Category].Unique().Contains("Package") AND thisRow.[Item Category]!="Package" AND thisRow.Rate!="",
Find(thisRow,thisTable.Filter([Item Category]!="Package"AND Rate!="")) + thisTable.Filter([Item Category]="Package"AND Rate!="").Count(),
thisTable.[Item Category].Unique().Contains("Package")=False() AND thisRow.Rate!="",Find(thisRow,thisTable.Filter(Rate!="")),
thisRow.Rate="",
"")
ThisTable.Filter(
CurrentValue.Category=thisRow.Category
&&(CurrentValue.Date<=thisRow.Date)
&&CurrentValue.RowId<thisRow.RowId)
.Sort( False(),ThisTable.Date)
.Sort(False(),ThisTable.RowId).first()
Sequence(1, [Multiselect Control].Count())).FormulaMap( AddRow([Order Table], [Order Table].[Order #],max([Order #])+CurrentValue, [Col1],[Multiselect Control].Nth(CurrentValue) ) )
[Table 2].FormulaMap( Concatenate(CurrentValue, " ", CurrentValue.Detail.BulletedList()) ).BulletedList()
Sequence(EndOfMonth(Today(), -1) + Days(1), EndOfMonth(Today(), 0)).FormulaMap( If( CurrentValue.Weekday().In(7, 1), 20, 15 ) ).Sum()
Concatenate((Sequence(1, thisRow.[Path From Parent].Find(thisRow), 1).FormulaMap(Character(9)).ToText().RegexReplace(",","")), thisRow.Level, ". ", thisRow.Title)