Best Of
Re: Conditional Formatting - One rule on multiple columns
Hello Genevieve, has there been any update to this? I need to use a conditional format to highlight any blank data cells in 25 columns for 4 different regions and the only time that the clone rule will save me is having to set the format. I have to manually change each and every condition and column to format for over 100 conditional formatted columns that I need.
I think it would be a wise investment for Smartsheet to allow multiple column selections when setting the condition for anything using the same criteria across multiple columns, this does not seem like it would be too hard of an implementation for Smartsheet to do since it already lets you select multiple columns to format based on setting the condition, the only thing needed would be a check box to indicate only format cells in the selected columns based on the criteria.
Re: Custom Colors for Sheets
How to enter custom color for cell background? — Smartsheet Community
I would like the ability to add custom colors to the pallet and bookmark custom colors for quick access similar to what most Microsoft products do.
Include Images in cells through Forms
Hello,
I am trying to put together a simple order form for customers and I would like to include the images of the items that are available for customers to order. This way they know exactly what they are ordering. It is my understanding that this feature is not currently available. I would like for Smartsheets to consider this idea. For small business, it would make things so much easier for them to order products.
Conditional formatting to enforce not bold
Conditional formatting seems to work one way -- force text bold, but not the other way around. Obviously I could manually do this, but there are many lines in our sheet.
The reason for this is because users at times will copy/paste certain rows in a sheet, and we use bold to distinguish the indent level. if a row or cells are bold, then there's no automated way to ensure they are normal font.
Recurring Tasks - Please.
Please create some kind of button/feature/right-click that will easily turn tasks into recurring ones (like in Asana or Microsoft Project). The amount of workaround hacks needed to get this to work is tiring, and puts off team members who are not as experienced with bullying Smartsheets into doing what they need it to do.
It would be extremely helpful for project plans within the very complex Media Agency industry, as we often have campaigns that have waterfall structure until go-live and then repeatable monthly/weekly tasks up until campaign ends (all included in one single project plan sheet). It would really motivate more agencies to adopt Smartsheets.
It's as easy as just having the start date for a workstream (indented group of tasks under a header) restart on a specified date/timing.
Example: Reporting tasks can only start after go-live (Start Date); however, they can only start on a Monday (Custom Timing Lag) and they repeat weekly until the end of the campaign (ends after the final End Date). It doesn't matter if the tasks are late or not complete, because a report is due every week anyway so it's not contingent on a previous week being marked complete.
Understand it can be done through formulas; however, it causes issues when you have an automated waterfall timeline that is extremely sensitive to delays. A lot of workarounds include having extra columns; however, those columns won't auto-push out if go-live dates change throughout the project unless you play with automations and formulas...and that results in two different start and due date columns that often confuse teams.
Just a thought!
Group Columns in Grid
Hi! I use a really large grid-style Smartsheet to track all aspects of project development and health. It would be very helpful to have a way of grouping columns. The hierarchy for rows works great, but I think with columns I am just looking for a way to clean up my views.
I feel like the best (and only) solution right now is to use the Reports. But now I have so many reports it's very difficulty to track all of that, too.
Report - Recent Changes
Having a Report that you could run on a Sheet to show recent changes/cell history would be extremely helpful. This would allow for admins to drill down into recent changes and understand potential next steps to take. Also, having a Report that would show recent changes could be easily exported out and shared with managers/leadership as to recent changes. Currently, the only way to understand changes is to utilize the Highlighter function, and then from there I write out an update. This is fine in situations where only a few cells/rows have changed but on larger projects where hundreds of rows are changing, it would be more efficient to have a Report collate this information. If the Report could show the cell history, that would be even better!
Re: Copy specific cells to another sheet
I am having this same issue. I am using a form to collect data from our customer that then needs to be automatically moved to our project management form, without pulling over columns. We simply need the cell data as populated by the sheet to be moved to particular cells in the destination sheet that we designate.
Re: Custom Colors for Sheets
I love this Idea and I think it's needed, I was in a Lab about sheets and colors at engage, and I wonder if this is on the roadmap already.
Re: Custom Colors for Sheets
Add more colors to the color picker for background and text colors and/or let user select custom color (as is the case legend colors in chart widget).
Same request for conditional formatting too.