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 join the conversation:
is there the ability to colour in a column not a row to show for example UK bank holidays or staff holidays etc.. to show in a very quick visual way any clashes that might be avoided.
Hi,
Unfortunately, it's not possible at the moment, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
You could use conditional formatting to format just the field in the column you're searching for rather than applying it to the whole row. If the fields in that column match your criteria, it would essentially color the whole row. You can also manually color in the row by highlighting the entire column and changing the color of the background.
Let me know if you have any questions.
I read your question wrong and that you meant the Column Titles.
Mike is right, and I often use conditional formatting in my solutions to color whole columns and rows to make it easier to keep the design as intended.
Andrée
The conditional formatting doesn't even have to apply to the column that is being used for the criteria. You could set it to highlight only the cells in column B where the corresponding cells in column A contain a certain value.
Exactly, I sometimes use it to format multiple months or values in that way.
Works great!
Andrée
Pinging this thread... assuming the column highlighting or formatting is not yet a feature implemented? Has someone worked out a work around?
Does anyone know how to add multiple rows to a request? I am only seeing an option to send one row at a time. In grid, you can select multiple rows and do one row update for them all, but I can't find this option in table view. Thanks! Regina
Hi there, I'm not sure if I'm losing my mind, but when I logged back into my sheet today I have lost the default colour settings for sub-milestones and status (see screenshot) How do I revert back to the default colours for these? Is there a way to do this? Many thanks.
Please help! I've tried Smartassist with no luck! I'm creating a project financial tracking template and have hit a challenge with charting. My source sheet contains one row per month and includes: Financial Month (stored as text) Actuals (Cumulative) Forecast (Cumulative) A helper column called "In Plan" that I use for…
