Row Options
Right click any row in Edit mode, and select "Set row options":
It currently has two options:
- Allow expand/collapse of row
- Is Cost
More options will be added here in future releases.
Allow expand:
This will allow you to turn ON or OFF expansion for individual rows, and now also specify if a row is cost or not.
Is Cost:
If you tick the "Is cost" box, the row will get a value of 1, which can be referenced using "Row().cost". This will return 1 for all rows where the box has been ticked.
To see and validate the "Is cost" value per row, you can add a custom column and write "Row().cost" to extract the values.
You can use these values in formulas and conditional formatting, like this example:
