Allowing a dash in a price column

AppSheet AppSheet Q&A
,
1

I have a price column that is use for a supplier rate. It’s INITIAL VALUE if referencing a rate sheet we have but is editable. We have some instances that there is no freight and our customer is requiring to return a dash when it is blank. But with a Price column a dash is not allowed. here is my current formula for initial value

ANY(
SELECT(
Rate[Rate],
AND(
[Origin] = [_THISROW].[Origin],
[Destination] = [_THISROW].[Destination],
[Supplier] = [_THISROW].[Supplier]
)
)
)

How do I add in that if my Driver column is “Customer Pickup” it will allow a dash

2

One option is , if you do not have other calculations depending on this column, you could make the column type as text, possibly with some valid_if constraints such as it will allow entry of only numbers and a dash.

IF( [Driver]=“Pickup”,

OR([_THIS]=“-”, DECIMAL([_THIS])>00.00),

DECIMAL([_THIS])>00.00

)