It would be helpful to be able to do conditional formatting for the entire sheet or by a row rather than column by column. It becomes very tedious to enter the same formatting over many columns.
We are currently exploring how we might improve conditional formatting in the future so we appreciate all this great feedback - thank you! When we have more details to share we'll update the status here.
It would be great to be able to multi-select "If [this column]..." columns in Conditional Formatting, so that we don't have to clone and duplicate the same formatting for many columns with the same condition.
For example, I have a number of currency-type columns and I'd like them to display in red font if they are less than zero. Do do this currently, I would need to clone the same conditional format many times for each individual column!
Alternatively, this could be achieved with adding an "OR" option, similar to the "AND" option.
I was under the impression Conditional Formatting already applied to every row that meets its conditions. I also know there's an Entire Row option so you don't have to check off every column.
Do you mean that you'd like the ability to apply a conditional format to every row in one column? [eg: if [row Count]# is Odd then apply this format to Column2]
I think I'm on board, but I might be misunderstanding. Could you provide an example?
I'd like to highlight all of the percentages over 100, but that would include the top row, which does not need to be highlighted. To exclude this row, I had to add another column and exclude that from conditional formatting.
ahh, I see.
yep, that's a pain and a half to set up.
I have 16 columns of data and I have to set 5 rules for each column. This causes me to have to create 80 rules which was time consuming
Did you ever do a sheet which needed many (e.g. 30 or more) conditional formats?
Currently it’s a tedious nightmare to create them and again, when changes are required.
I request a substantial overhaul of this functionality with use at scale in mind.
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
I would love to see the conditional formatting feature to be updated to format an entire sheet at once.
I.E: "If this symbol is anywhere on my sheet, apply this formatting to the cell (or row)"
I primarily work in column based sheets with sometimes in excess of 100 columns - each of which have 2 or 3 formatting rules to apply. The process is tedious in a singular column format. Being able to conditionally format an entire sheet at once based on the data in the cell would be a game changer with what can be done on large column based sheets.
I have wished for this feature more times than I can remember over many, many years. My latest use case was wishing to highlight any cell that includes the phrase "USAGE NOTE." FYI, I'm in software QA and project management, FWIW.
I'm currently in Conditional Formatting hell where I'm applying the same conditional formatting across many columns. I have 5 rules for each column. I create them for one, and then keep cloning and updating settings. It would be great to be able to apply to multiple columns, or the entire sheet, at once.
Currently, a conditional formatting rule applies to the whole sheet. Please add a feature to be able to select a range, similar to Applies to in MS-Excel:
Please add this feature. There is a serious need for this! I am currently having to manually create formats for 67 columns in a sheet x 3 conditions per cell. This should be an easy update. C'mon smartsheet.
Ugghhhh Same! I have to build 3 or 4 conditional formatting rules for almost 100 columns. Its maddening. And SO easy to mess up.
Full sheet formatting would literally save my work sanity.
We need this. I am in a conditional formatting nightmare.
Excel handles this much better. Seems like achieving a similar level of capability would not be too hard to do in Smartsheet. cloning formatting for each column can't be the answer! Help!
There are feature requests for this going back to 2020. Why is this taking so long.
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…
Smartsheet should have option to copy a specific action and reuse it within the Automation. This will save a lot ot time of building Automation where repeative action needs to be places under different condition. Similar faicility is available in Microsoft Power Automate where user can copy some aciton and reuse the same…
Hi, Currently when one wishes to link a form in a dashboard (not display a form, i mean hyperlink! but guess it would apply to forms in a dash too) You would need to get the url first of the sheet where the form derives from. Instead, it would be handy that when adding a hotlink, it would pop-up when 'Smartsheet item' is…
It would be fantastic if there was a built in way to group reports by month or year based on a date column. Something in the group settings when you choose group. If you select a date column you would have these options Oldest to Newest by Year Oldest to Newest by Month Oldest to Newest by Day Newest to Oldest by Year…
©2024. All Rights Reserved Smartsheet Inc.