If I want numbers less than say 3 to allow decimals but if its bigger than 3 it must be a whole number, how would I do that? they can be up to around 300-400 and can only have 2 decimal places if lower than 3.
One column that is always a decimal that holds the number, and then a Text VC that formats as you wish.
You’d have to use Valid if to enforce this. Try:
OR( (ABS([_THIS]) < 3), (DECIMAL(NUMBER([_THIS])) = [_THIS]) )