Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Automatic Column Updates?

Bianca Gordon
edited 12/09/19 in Archived 2017 Posts



I am trying to create a formula that is set for the whole column in the sheet. What I want to happen is whenever the Status of the Harvey Ball is full, the "Done" column well create a check mark in the cell. Is this possible? If so, how? 




  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



    The formula is


    =IF(Symbol23 = "Full", 1, 0)


    if your Harvey ball column is named [Symbol] and the row is 23.

    Copy that formula to the rest of the cells in the column.


    There is no way to have a "default" column formula, the formula needs to be in every cell.




This discussion has been closed.