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.
Prevent inheriting formatting from previous row.
I have a sheet where the first row is populated with instructions on how to complete each column (becasue the column title text is so limited - but i digress).
That row is formatted in a green color to set it off from the actual data rows. The problem is, when I go to enter data in the next row (2), that row automatically changes to the above row's green color.
As i type this, I realize i can do a conditional formatting rule that sets the format to "no fill" when the primary column is empty or populated, but I'd rather not have to do that.