This option would be extremely helpful. It's so tedious to set up now when you have to set up a format for each column even though you're looking to set up the same condition for multiple columns across the sheet. It would be so much easier to be able to say if there are blanks in all these columns make make that cell this color.
I agree with all the comments that point to the need for a better and more scalable approach to this.
Allow conditional formatting to work like it does in excel where i can just select the columns/rows that I want to apply conditional formatting for and then set up the rules. The current method of setting it up by column is very challenging for large sheets with multiple columns and different conditional formatting.
Additionally, allow the conditional formatting from Excel to be imported in to SmartSheet.
I would very much like to see this much requested feature implemented too.
Here I am this evening creating a Training Matrix for 18 staff with 18 columns (staff names) with 120 Training aspects on the rows and 4 levels of competency for each cell
So at the moment, instead of 4 rules to give a cell value or 1,2,3 or 4 a different colour I will be faced with 18 x 4 rules = 72 rules - which I don't think I can face doing!
I'd like to see Conditional Formatting being much more flexible please
I'm commenting to boost the bejezus out of this idea.
For 5 years now the single most frustrating element of the SS platform for me is the lack of full sheet formatting. I will die on this mountain.
We work with some sheets that have the max of 400 columns. All of which have 3 or 4 levels of formatting that need to be applied.
Anyone wanna take a guess on how many days it takes to apply 1200 conditional formatting rules without missing a single one, or messing any up? My sanity is SEVERELY tested on those days.
Being able to say "If this symbol is anywhere on my sheet, do this" is all I would ever need. Even simply being able to toggle in the formatting rules between individual columns or "Apply to full sheet" would be an insanely helpful enhancement.
I'd like to boost this post as I'm currently facing a 35x35 dependency grid formatting exercise with each 3 different formats. I was hoping to find a simple solution here but unfortunately I found this post :) ... so I might continue to test my sanity in building the column formats knowing that I'm not alone! If there is a a better way to push this into the development queue please let me know. Thanks, Iris
Everybody who reads this thread and agrees on needing this functionality should go to the original post in the thread and up-vote it. The more votes it gets, the more weight it's given when the Smartsheet development planning occurs.
Please can we have a way to apply formatting to multiple columns at the same time (or more quickly and easier than having to do each one individually when it is the same rule being applied).
I would like to bump this requests as well.
I have sheets where I have a need to highlight the entire column based on the value in each row. In specific, we have Week Ending columns, with the week ending date in Row 1.
I want to highlight an entire column when the value in Row 1 matches the current week ending.
This has come up multiple times, and I can never find a solution other than to tell my users "Smartsheet cannot do that".
While we are on the subject of row and columns not having the same treatment. Why can we freeze columns, but cannot freeze rows. Again my solution is to say "Smartsheet cannot do that"
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…
Is there a way to display all product feedback (i.e. enhancement requests) I have submitted? If so, could you please email the link for that? If not, it would be nice to have in a future release. Thank you.
Tableau has updated their server and desktop and the Smartsheet WDC has been deprecated due to the Smartsheet web data connector being based on an old SDK. I rely on this data connector for many dashboards which are now very out of date and/or blank since I am no longer able to refresh them. Please update your connector so…
Although it's typical to need to run a few tests for a workflow or automation, it would be great if we had the option of previewing what the automated emails/notifications/alerts would look like for individual users with different types of permissions. A view "View As" type of feature.
©2023. All Rights Reserved Smartsheet Inc.