Override Column Formula for Particular Cells

LukeSmartsheet104

It would be great if we could edit single cells within a column that has a column formula in place without having to convert it back to a Cell Formula! That way if we have accurate data for one cell, we can change it and still keep the formula for the rest of the column!

Lee Joramo

To add an additional aspect of this, I often find that I want different formulas for nested rows. For example, the child rows have a column that calculates some values, and the parent column should be the sum of its' children. This can be done by using supporting hidden columns and/or complex nested '=if()' statements in the column formula, but it could be much easier.

Lucas Rayala

@LukeSmartsheet104, here's a quick workaround suggestion. Create an override column (call it "Override"). Assuming that "<Your Formula>" is your original formula, update it as follows:

=IF(Override@row<>"", Override@row,<Your Formula>)

This says, IF you enter any information in the Override cell, your column will display that cell's information. OTHERWISE, it will use the original formula.

Hope this helps!