conditional formatting is not correctly transferred to another sheet

Miranda_1

I use conditional formatting and have the following problem:

I copy lines from one sheet to a second sheet.

When I do this, the conditional formatting changes from (source sheet)

to (target sheet)

what am i doing wrong?

thanks a lot

Andrée Starå

@Miranda_1

Yes, unfortunately, it's not possible, at the moment, to have the Conditional Formatting rules added automatically when copying/moving rows, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Miranda_1

I hope you're well and safe!

You must change the Conditional Formatting on the other sheet to match the first.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Miranda_1

hi andrée,

thanks for your answer.

of course i can do that. but why is the coloring of the conditional formatting not taken over completely? there are also colorings on the same sheets that are taken over correctly... and not only "similar". this leads to a lot of fine tuning. can't smartsheet do that better?

Andrée Starå

@Miranda_1

Maybe It wasn't set up with the same colors, or maybe if a copy was made, it was something from earlier with the colors used.

Make sense?

Or did I misunderstand your question?

Miranda_1

hmm, does this mean that conditional formatting cannot be transferred to a new, blank sheet by copying lines?

Miranda_1

we only use colors from the standard color palette

Andrée Starå

@Miranda_1

Yes, unfortunately, it's not possible, at the moment, to have the Conditional Formatting rules added automatically when copying/moving rows, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

LoriFR

[9:22 AM] LORI RAUB

I FIGURED IT OUT! What you showed me was only half the trick! What I needed to do in order to copy the sheet rules was to delete all the lines from the sheet created using the copy entire sheet, this keeps all the sheet rules in place. Then select and copy all the rows from my sheet containing any proofs, links, etc, into that sheet using the "copy to sheet" and select all the links etc. This worked! Yay! It kept all the color rules and links!