Sign in to submit new ideas and vote
Get Started

Override Column Formula for Particular Cells

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!

3 votes

Idea Submitted · Last Updated


  • Lee Joramo
    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
    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!