nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Sign in to vote on this idea

Prevent the Copy and Pasting of formatting in conditionally formatted cells/rows in Table View

Chase Evans

I was just recommended table view as the new replacement for grid view, I've used it once or twice to utilize some new features in table view and was just starting to consider switching all my grid sheets to table until I went to go copy and paste a cell that had conditionally formatting applied into another cell and it copy/pasted the formatting as well! this is something I definitely do NOT WANT, this is not desirable behavior under any circumstance. Is there any plan to fix this? If not, I do not see tables as a full replacement/upgrade over grid any time in the near future.

Find more posts tagged with

Sheets

Idea Submitted

Enhancement Request

Comments

Paul Newcome

I agree. Pasting should be the values only the same way it is in Grid View. Adding my vote. I can understand if the formatting was manually applied, but I feel conditional formatting should not copy over.

Chase Evans

Glad I'm not the only one! I switched back and forth a few times to verify I wasn't doing something wrong - can't believe this was overlooked or changed. I can't think of a single instance I would want it to behave like this. One of the reasons I really like the Smartsheet conditional formatting other than this newly discovered issue is that it just works (theres a few gripes with the available conditional options) as opposed to excel which is just a messy nightmare and breaks half the time you copy/paste info.

Paul Newcome

I have played with it a bit more and found that it seems to be related to the copy part of copy/paste. If you copy in Grid View, it only copies the value. If you then switch to Table View and paste, it only pastes the value. It only picks up the formatting when you copy while in Table View.

I would also suggest submitting a ticket to support because this may actually be a bug or something overlooked as opposed to intended functionality that would require a Product Idea to get changed.

Pavel T.

I fully support. I like the new table view but this behavior is very annoying. Can't wait till it is fixed.