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.
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
