Since we are using dynamic ranges, you wouldn’t think that it would be possible to change a value within a dynamic data range, but there are times where this is not only possible, but desired:
In this example, we are using a Custom Field that had Blank Values (blank).
However, we may not want to see that in our report analysis.
So just click in any field that contains '(Blank)' and change the value to '0.00'. You will notice that all of the values previously showing ‘(Blank)’ will be changed to '0.00' - all by changing only one cell with the '(Blank)' value.
These WILL remain, even when you refresh your spreadsheet.
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/111/custom-data-values