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.
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
