Forum Discussion
How to turn off inconsistent calculated column formula for a column in a table
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 colum...
Best practice is:
One column -> one formula.
One column -> one data type
Especially in Excel tables.
You could do =IFERROR(your_formula,some_text).