Override column formula for specific cell

I would like to override the column formula for specific cells.

Example, If the description for a product had a column formula like
concatenate(make, " ", model)
and I had a couple of cells that did not fit this pattern, I would like to be able to manually override the description for those cells to something else.

I love the product.

You can add something like a Switch statement to the formula to check for the conditions you need in order to use the correct logic. For example…

/edit - the SwitchIf statement is also very useful for this kind of thing. You can’t manually type into a column that has a formula.

1 Like