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

%3CLINGO-SUB%20id%3D%22lingo-sub-1479572%22%20slang%3D%22en-US%22%3EHow%20to%20turn%20off%20inconsistent%20calculated%20column%20formula%20for%20a%20column%20in%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479572%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20just%20discovered%20tables%2C%20which%20I%20like%20very%20much.%20However%2C%20I%20have%20several%20columns%20where%20the%20input%20is%20mixed.%20I%20have%20a%20formula%20that%20references%20a%20pivot%20table%2C%20which%20I've%20copied%20down%20the%20whole%20column%2C%20but%20not%20all%20the%20entries%20are%20found%20in%20the%20pivot%20table%2C%20so%20sometimes%20I%20overwrite%20them%20with%20a%20text%20description.%20This%20gives%20me%20the%20inconsistent%20formula%20message.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGenerally%20I%20find%20this%20feature%20useful%2C%20but%20I%20would%20like%20to%20turn%20it%20off%20for%20this%20column.%20Can%20I%20do%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20-%20Helen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1479572%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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

1 Reply
Highlighted

@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).