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?

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

Hi 

 

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? 

 

Thanks.

Tags:
· Share on FacebookShare on Twitter

Comments

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

    Bianca,

     

    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.

     

    Craig

     

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories