I’ve run into an odd issue that I’m hoping someone out there has found a workaround for :slightly_smiling_face:
I have a table consisting of recurring tasks, where each task is assigned a value ($). A zap creates assignments based on those tasks and values in a separate table.
I need to be able to override the value of the task in the new table; which is pretty straightforward… but I’m running into issues if I want to override the price to be $0.00. Airtable seems to treat Currency fields (and probably number fields too, haven’t tested it) the same whether they are BLANK() or have a value of $0.00.
Here is the formula I’m using (in a rollup field):