- Conditional Formatting on sheet level & row
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.
- Conditional formatting in Gantt not working with dependencies
For some reason it seems like my conditional formatting rules aren't being applied to certain rows in the Gantt chart side of this sheet. The problem is resolved if I disable dependencies, but I need those and don't understand why this should matter since I don't have any rules related to status or % complete in the…
- Conditional Formatting Primary Column Indention
Is there any way to indent specific rows in the primary column that meet a specific condition, like through conditional formatting? For example, WBS ID is the Primary Column. I would like to indent that row if the Activity ID is not blank. It appears that the only way to do so is manually indenting/outdenting.
- Edit contact display?
Hi Do you know if you can edit the display of a contact in an assigned to column? Ideally I just want to see the initials in the icon and not the name/ email that follows. Thanks, Jo
- Can you make a field required on a sheet?
Hello, We use a sheet for our HR departments. We want to have a field required to be filled out based on a drop-down menu selected. So if the status of the drop-down is HIRED, they should need to fill out who the direct Report is, so the data is complete. This is not on the form. This is directly on the sheet. Thanks in…
- Join Formula with Dates - How to eliminate the time stamp?
I am using the join formula to combine the task name, start date, and end date into a single column that will be used for reporting purposes. The start and end dates are formatted to only show the date, not a time, however when I use the join formula, it's giving me 'Task Name -- ##/##/## 8:00 AM - ##/##/## 4:59 PM" and I…
- Conditional Formatting: Changing Cell Color Based on 3 Separate Date Ranges
Hello All, I'm trying to set up conditional formatting where colors change based on how many days they are away from an automatically generated reference date (Helper Column). Currently I have it set up so that in when the reference date is in 15 days, the "date certified" column will turn yellow, in 5 days it will turn…
- 条件格式在附件基础上,像nts, un/locked status, etc.
Hi Smartsheet, I'd like to see the ability to create conditional formatting based on if a row has attachments, comments, is un/locked status, etc. These features are in the "side margin" on the left hand side. ie. If a row contains an attachment change the font to BOLD. ie. If a row becomes locked highlight a cell a…
- Conditional Formatting for Dashboard Metric Widgets
When using dashboard metric widgets, it would be helpful to be able to have conditional formatting features to compare performance to a KPI or otherwise enhance the metric display. Even if the data source document already has the conditional formatting existing, it will not transfer along with the data to the dashboard…
- When a copy row automation is triggered, is there a way to only copy certain columns/cells?
When a copy row automation is triggered, is there a way to only copy certain columns/cells in that row? I saw in a post from 2020 that this was not possible yet. Is this possible now in 2023?
