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.
As one of the system admins, it is absurd to me that I cannot view or have access to all of the items created in my organization. We have over 11,000 reports, sheets, and dashboards and I can't see them. I have no visibility to if people are using our plan for their own personal use, or what kind of work is going on unless…
I noticed this the other day and tested Ctrl + M – it does not work. I submit ticket to Smartsheet support – they told me that’s expected behavior because it’s not currently available even though it still shows as keyboard shortcut in the menu🙄 and told me to submit new product idea. Please add this keyboard shortcut to…
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
