How to turn off inconsistent calculated column formula for a column in a table

[teapot2002]

I have just discovered tables, which I like very much. However, I have several columns where the input is mixed. I have a formula that references a pivot table, which I've copied down the whole column, but not all the entries are found in the pivot table, so sometimes I overwrite them with a text description. This gives me the inconsistent formula message.

Generally I find this feature useful, but I would like to turn it off for this column. Can I do that?

Thanks - Helen

[#2]

@teapot2002 

Best practice is:

One column -> one formula.

One column -> one data type

Especially in Excel tables.

You could do =IFERROR(your_formula,some_text).