When a row is on the critical path, I'd like to be able to set conditional formatting so that it turns text red, or colours the cells, so that it is a more obvious visual cue that this task is a particularly important one.
Sign in to see the current vote count, add your own vote, or leave a comment.
Hey @Julian Sindall
You can use the function ISCRITICAL to identify if a row is on the Critical Path or not. For example:
=IF(ISCRITICAL([Task Name]@row), "Yes", "No")
Then once you have this in the grid of your sheet, you can set a Conditional Formatting rule based on that formula column!
Cheers,
Genevieve
Thank you - that's a useful workaround. I'll use that. Obviously it would be more data efficient to be able to conditional format directly, but this will do in the meantime :-)
I like the conditional formatting based on critical path, but I would love to see the rows of the grid that correspond to the gantt bars highlight when you select to show critical path or show summary path.
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
Be able to print and/or export Workflow Automations in PDF and/or export to Visio. this would be used for document control and troubleshooting aid
It would be extremely beneficial to have the ability to manually assign colors to individual projects within the Timeline View. Currently, project colors are automatically determined by the Dashboard Theme, which limits flexibility and makes it challenging to visually differentiate projects in a meaningful way. Allowing…
