I have a decimal column with auto compute value (it adds and divide the values from the other columns, decimals also) the problem is that if the row is updated with no values at all, the autocompute will put 0,0 and this will be added to the sheet. In the formula i do have conditional formulas so that in case that the other columns are 0, then the autocompute column should put the value " " but it wont do it, still it gives 0,0, probably because as decimal wont accept a blank space, nevertheless how could i make this autocompute column to become blank (or any sign that is not a number) when the row is updated and the other columns have empty values?
Just solve it using IFS !!! i was reading other posts…thanks to appsheet team